hide en unhide sheets

[already]

Hi

How can I prevent users to hide/unhide sheets when my worksheet
is protected

Kind regards

Al

 

[VoG]

Try protecting the workbook structure.

 

[Johnny C]

You can also make sheets 'very hidden' so they don't appear on the list of sheets to unhide, but you need some VBA to do that - very easy though

 

[btadams]

Open the visual basic editor (Alt+F11) and on the left hand side you should see something like VBAProject(Your Workbook.xls) in the Project window. Select the worksheet you want to hide and then in the Properties window (which should be below the Project window. If it is not there, go to the View menu and select Properties Window) change the Visible property to xlSheetVeryHidden

 

[already]

Hi

Thanks!!! both solutions are OK

Kind regards

Al