Can I hide a worksheet and set a passwd to unhide it?

  • Thread starter Thread starter puneetarora_12
  • Start date Start date
P

puneetarora_12

Can I hide a worksheet and set a passwd to unhide it?


Puneet Arora
 
you can hide a sheet on the format> sheet menu.Dont know about the password
thng tho sorry
 
You can hide a worksheet, even hide it from the Format/Worksheet/Unhide
dialog (by setting the sheet's .Visible property to xlVeryHidden), and
then use macros to unhide and rehide it. The project would have to be
secured with a VBA password.

However, this is not particularly secure, as VBA passwords can be broken
easily.

puneetarora_12
 
You must log in or register to reply here.

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

Can I lock a set of cells in a worksheet? 3
hide, unhide column or row after protect worksheet 4
Unhide a row 1
Hide and unhide...what the heck!!?? 6
Hide Column 2
Unhide isn't working 3
Unhide macro worksheet 2
Not able to unhide sheet in Excel 2002 2

Back
Top