How do I lock options and scrolling in Excel?

R

Radar

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.
 
D

Don Guillett

set it each time the wb is opened by using a workbook_open event macro in
the ThisWorkbook module.
 
Top