Adding a password for a hidden sheet

MonkeyFace28

Board Regular
Joined
May 30, 2014
Messages
74
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
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

vds1

Well-known Member
Joined
Oct 5, 2011
Messages
1,193
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,959
Messages
5,525,901
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top