Adding a password for a hidden sheet

[MonkeyFace28]

Hiyas

Quick question, I have two sheets that I have hidden via the visual basic application, they are set to very hidden, but if the client knows how to work Excel... they could still technically unhide the sheets... so I want to password protect them as well as hide them. Is that possible?

Thanks
Steph x

 

[vds1]

You can lock the VB screen from Viewing.

Goto VB Screen | Tools | VBA Project Properties | Protection | Check Lock project from Viewing and insert passwords.

Save the file. Reopen and check.

 

[MonkeyFace28]

fabulous!! works perfectly! well done old chap x