Quote Originally Posted by martindwilson View Post
not sure how 2007 is set up,but you should be able to run macros if yoou allow them,then again your company may have set it so you cant!
that code goes in the workbook module
see image
Excellent! That was very helpful. I managed to finally get one worksheet corrected so that the scroll area was limited to the area I desired. However, I now need to know how to apply this to the other sheets in my workbook. When I open the next sheet and use ALT/F11, I see the same code that I applied to the previous sheet. Do I simply edit the sheet name in the code?

The code I have entered looks like this:

Private Sub Workbook_Open()
Worksheets("Internship 1").ScrollArea = "A1:BX65"
End Sub

Sheet 1 is named "Internship 1". My next sheet is named "Internship 2". I'm not sure if I just edit the name of the sheet on the command line or enter an entirely separate command.