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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

scroll area 1
Scroll Lock for selected multiple sheets 2
Setting Scroll Area in Excel Worksheet 5
Scroll area lock- again 4
Unremovable horizontal scroll bar on subform 1
ScrollArea 2
Where best to place an instruction in a VBA script 4
Copy Multiple Areas from One Workbook to Another 4

Top