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