Problem with script to password protect and hide a sheet

Hello!

Real brief summary; I have a workbook I need to distribute but I do not want the users to be able to see the contents of two of the sheets in it ever.

I am trying to use a code to hide a sheet and require a password to open it.

Currently I have

Please Login or Register  to view this content.

This works fine despite showing the sheet when it asks for the password (I got around this by making all the cells white text/white background.

The one problem I am seeing is when a user opens the file, if they do not enable the macros, they can unhide the sheets all they like and see the data.

You have to force users to enable macros. You do that by using a Splash screen that is visible with instructions on it and setting EVERY other sheet to Very Hidden (in the VBE or using code). Then, when they enable macros, you display the password dialogue. If they get it right, you hide the Splash screen and unhide other relevant sheets. Look for examples of forcing users to enable macros ... tedious to set up but can do what you want. That said, Excel is inherently insecure and it's no big deal to get at hidden sheets.

Regards, TMS

You're welcome.