[VBA CODE] Password Protect a hidden sheet while using other code

Hi, Everyone.

I am currently using a VB code to enforce the enabling of Macros as my workbook heavily relies on VB and Macros.

The code is as follows:

Please Login or Register  to view this content.

the sheet "Supervisor Review" is soft hidden (can be un-hidden by right clicking on the sheet tabs). What I am trying to do is require a password to unhide this specific sheet and this sheet only. I tried to use the basic "Protect Workbook" structure, but that interfers with the enforce macro VB code. Any ideas?

Thanks in advance!

This works almost perfect! I really do not mind having to enter the password every time the sheet is hidden/unhidden, in fact I think I prefer it in case the workbook is emailed to someone after unhiding said sheet.

I noticed that when you right click > unhide the sheet, prior to requesting the password it still loads the sheet. Although you cannot scroll to see the full data, without entering the password, you can still see a good chunk. Any way to block that?

This worked great, I had to modify the "Activate" line but seems to be working great now!! Thank you very much! Your knowledge and time is very much appreciated! (rep added)

If you do have sometime, I am pretty new to VB and am eager to learn. Could you explain why this particular code needed the separate module to run? (this is the first time I run into that..)

Originally Posted by Tsjallie

This demo will not require a password all the time and not predisplay the sheet.

got it! Thanks again for all your help!! It is very much appreciated!