Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Limit The Worksheet Scrolling

A few days ago, somebody asked me how to Limit the scrolling of a worksheet as soon as he opened his workbook file. He intended to make the first sheet as a Title Page so he should find a way to do it. At first, I thought it was just a simple Excel "setup" workaround at the Tools menu. But after a few minutes of looking around it, I didn't find a way to do the task (or maybe there was one but I didn't find it). So, I ended up making a simple Macro program at the workbook's "Open" event. Here's how I did it:

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "a1:f10"
End Sub

The code limits the scrolling of the worksheet from cell A1 to F10 only.

Try it.

Visit the PRO-BUSINESS EXCEL VBA PROGRAMMING blog for more interesting tips.

This post first appeared on Pro-business Excel VBA Programming, please read the originial post: here

Share the post

Limit The Worksheet Scrolling


Subscribe to Pro-business Excel Vba Programming

Get updates delivered right to your inbox!

Thank you for your subscription