How do I lock options and scrolling in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Each time I set the ScrollArea property in VBA so that users can't scroll
down my worksheet, it remains but only until I close the sheet down. Once it
is re-opened, the property is blank again (despite saving it inbetween). Why?
I also want to lock the options menu for a specific spreadsheet, so that
users cannot choose to turn scrollbars or tabs on, but I cannot work out how.
I'm sure this used to be simple in Excel 2002....any help greatly
appreciated.
 
set it each time the wb is opened by using a workbook_open event macro in
the ThisWorkbook module.
 

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

Vertical Scroll issue with Excel 2013 1
How do I conceal the unused range from the scroll bar? 1
scroll lock in Excel only 3
How do I turn scroll lock off (2007 excel)? No scroll lock key 1
How do I deactivate scroll lock. 5
How to lock scrolling? 2
Can't move between cells. (Not the scroll lock) 1
how do i turn off the scroll lock. 2

Back
Top