Adding a password for a hidden sheet

MonkeyFace28

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
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Hiding Sheets during the Before_Close Event
2
Replies
10
Views
299
Jaafar Tribak
Jaafar Tribak
A
  • Solved
Activating hidden Sheets using If statement.
2 3
Replies
23
Views
693
kevin9999
K
H
  • Question
How to hide some columns while allowing users to 'Format Columns'
Replies
2
Views
283
hcgood
H
F
  • Question
Filtering/Copying a table via VBA.
Replies
2
Views
124
frobeniusabnorm
F
W
  • Question
multiple password protected pages with same password and using macros
Replies
0
Views
462
WindowGuy
W

Forum statistics

Threads
1,215,064
Messages
6,122,942
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top