I have a workbook that I've put alot of effort into and would like to protect the best I can. I have protected the sheets with a password but I would also like to go a little further.
My plan is the following.
Create a new sheet called "Enable Macros"
This sheet will have a Simple message that Macros must be enable to use the workbook
Set all other sheets to very hidden.
What I am looking for is a code to do the following
When workbook is opened Hide sheet named "Enable Macros"
Set all other sheets to visible
When workbook is closed (and saved) set all sheets to veryhidden and unhide sheet named "enable Macros"
my though behind this is that if someone saves the sheet as a basic excel file when they open it they will only see the sheet "Enable Macros" with test telling them to enable the macros. And, as the workbook hides the other sheets when closing the file they cant just open it once and then save it without macros.
Can anyone help or even advise on another/better method. I hope i've explained this well enough.
Thanks in advance
Bookmarks