password protect unhide sheet command

J

jimmill

I want to keep some data analysis sheets hidden from users who access a
shared workbook. I can use the hide sheet command but can I stop anyone else
unhiding the sheet?
 
J

Jim Thomlinson

Unknown to most people sheets have 3 visible states. Visible, Hidden and Very
Hidden. The last one can only be accessed via code or the VBA window. Here
are some simple instructions too make your sheet very hidden.

Right click the Tab you want to hide and select View Code
When the macro screen opens up hit F4 to bring up the Properties Window(if
it is not already on)
The last property for the sheet is the Visible property. Change it from 0 -
xlSheetVsible to 2 - xlSheetVeryHidden

Note whiel this is not entirely foolproof there are no foolproof solutions
in XL. this will keep out 99.9% of people.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect & Hide Sheet 3
password protect a sheet 5
hide, unhide column or row after protect worksheet 4
Unhide columns 2
hide/unhide has vanished 4
Unhide Multiple Sheets 2
Password Protect a Sheet 1
Command button unhides but not hides 1

Top