Ive tried disabling scroll on sheet 1 of my workbook by entering the cell range into the properties window in VBA. However when I save the sheet and reopen it, it seems to reset and are able to scroll again.
I tried using the following:
[vba]Private Sub Worksheet_Activate()
Worksheets(1).ScrollArea = "A1:Q51"
and a few variations of the above but this dosnt seem to be working. The only other code I have in the workbook is under "thisworkboko" which is this:
[vba]Private Sub Workbook_Open()
Application.DisplayFullScreen = True
so I dont know why its not working
Thanks in advance