Connection78
New Member
- Joined
- Jul 14, 2021
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
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.
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.