Hey guys,
I have created a spreadsheet that has many tabs, many buttons and many macros. All of the current VBA codes are only for ToggleButtons and are work fine.
I now want to lock the scroll area and zoom for each individual tab (they differ somewhat).
I tried this code but it did nothing:
Private Sub Workbook_Open()
Worksheets("CONTROL CENTER").ScrollArea = "$A$1:$O$25"
End Sub
I put this code into the same collection of VBA codes that I've already successfully setup, but I can still scroll wherever I want.
Thanks in advance,
Danny
Bookmarks