Scroll Area

S

Sunryzz

I am trying to create a scroll area when a certain workbook is opened. I put
this code in the ThisWorkbook object.

Private Sub Workbook_Open()
ScrollArea = "B13:B14"

End Sub

However, it does not seem to run when I open the workbook. If I just put
the range of B13:B14 into the scroll area on the worksheet properties, it
works, but as soon as I save the worksheet and close, it resets and is not
there when I reopen. Does anyone have an idea of what I might be doing
wrong????

Thanks
 
Top