VBA Very hidden worksheet password function not working

[Connection78]

It's been a while since I used VBA's in Excel to get a worksheet to be very hidden and password protected. Last time I was able to do it at my previous employer on my work computer. Now I'm trying to do it on my personal computer.

So here is my case. I want to hide a particular worksheet and when I open VBE I am able to change the visible status of the worksheet to very hidden, no problem with this step. I then open the VBAProject - Project Properties dialogue box and under the protection tab I type in my password and tick the 'lock project for viewing' box and then press OK and close the dialogue box. And as expected this worksheet is now hidden. However, here is the problem. When I go back and change the visible status back to visible, I get my worksheet to show up but it does not require me to type in a password.

 

[ZVI]

Hi,
You need to save workbook and reload it.

 

[AC PORTA VIA]

After you make sheet hide and vba project protected you need to save it

 

[Connection78]

Hi,
You need to save workbook and reload it.

I've tried this, still doesn't work.

 

[ZVI]

Hm, try changing your password, there seems to be one that doesn't work.
Questions:
1. Is there any code in VBA modules?
2. Whether a password is requested when trying to view the code?

 

[Connection78]

Hm, try changing your password, there seems to be one that doesn't work.
Questions:
1. Is there any code in VBA modules?
2. Whether a password is requested when trying to view the code?

Thanks for the reply,

There's no other VBA code in my file.

 

[ZVI]

Any code is required, just add something like this, save workbook into XLSB or XLSM format and reopen it:

Private Sub Dummy()
End Sub