Thread: hide formulas
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default hide formulas

The password on sheet protection is easily cracked so be aware that hiding the
formulas keeps only the novice from seeing them.


Gord Dibben MS Excel MVP

On Wed, 30 Aug 2006 02:16:02 -0700, Max wrote:

.. it has no effect until it is protected.


Just to add on a little to complete the above line ..

The "it" refers to the worksheet,
so we'd need to apply sheet protection via clicking:
Tools Protection Protect Sheet Password? OK
to achieve the desired effect of hiding the formulas