Lock hidden cells Mark Allen 12/31/2008 3:17:00 PM Is it possible to hide cells and stop them from being unhidden without a password ??? Regards Mark

RE: Lock hidden cells Eduardo 12/31/2008 3:37:25 PM Hi Mark, Hide the cells and then protect the worksheet "Mark Allen" wrote: [Quoted Text] > Is it possible to hide cells and stop them from being unhidden without a > password ??? > > Regards > > Mark

Re: Lock hidden cells Gord Dibben <gorddibbATshawDOTca> 12/31/2008 4:36:26 PM 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 On Wed, 31 Dec 2008 07:17:00 -0800, Mark Allen <MarkAllen[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Is it possible to hide cells and stop them from being unhidden without a >password ??? > >Regards > >Mark