Excel hide cells or single sheet
Posted on 2009-12-20
I have a sheet with financial tables that I would like to password protect... but the tricky part is I only want certain cells on the same sheet to be hidden "invisible" until a password is entered. Any other person can see the rest of the sheet and use the visible cells.
If this is impossible an alternative is that i could password protect "sheet2" so how can i make it so the work book can be opened, sheet 1 is available but sheet 2 cannot be opened unless a password is entered?