How do you hide AND protect an excel sheet

rtruesdale

New member
Joined
Oct 31, 2011
Messages
1
Reaction score
0
Points
0
I have two sheets i want to not only hide but require a password to view. how is this done?:confused2:
 
Well... you can't exactly do that through the standard user interface

You could do this though:
  • Hide all the rows except row 1
  • Hide all the columns except A
  • Protect the worksheet
This would force someone to unprotect it before they could unhide the rows and columns.

To request a password to unhide and view a worksheet all in one go, you'd need to resort to VBA code. (We can help you with this, and it's built into Excel.)
 
Back
Top