Auto hide & protect worksheets before closing

Hi folks,

I wrote the following code to hide & password protect an excel sheet :

Please Login or Register  to view this content.

How could I alter it so that it hides and protects this sheet automatically before closing the workbook ?

Thank you!

Hi magnum206

in the workbook module place

Please Login or Register  to view this content.

Originally Posted by intervals

I am trying to implement this in a spreadsheet I have and I cannot get the code to work.

I have 5 sheets
I want sheet "Info" to remain visible
But sheets, times, Email, Print, Run Comp, Leaderboard to hide when sheet is closed.

Firstly, You will need to FORCE users to enable macros.

Multiple versions of 'Force Enable Macros' code exists (just google). Here's one: http://xl-central.com/force-users-to...-workbook.html

After implementing code to Force users to enable macros, you will need to modify it to suit your requirements.

So using the example given at xl-central,

Please Login or Register  to view this content.