Lock hidden cells

M

Mark Allen

Is it possible to hide cells and stop them from being unhidden without a
password ???

Regards

Mark
 
G

Gord Dibben

Mark

You cannot hide individual cells.

Rows and columns, yes.

Then protect the sheet with a password, which is very easy to crack.

You can hide the contents of cells and what is seen in the Formula Bar.

To hide cell contents, custom format to ;;;

To hide formula bar contents, format to "locked" and "hidden" then protect
the sheet with the easily-cracked password.


Gord Dibben MS Excel MVP
 
Top