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"
The code limits the scrolling of the worksheet from cell A1 to F10 only.
Visit the PRO-BUSINESS EXCEL VBA PROGRAMMING blog for more interesting tips.