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