View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Hiding formulas in a Worksheet without password

You can select the cells with the formulas that should be hidden
Format|cells|protection tab|click locked and hidden

Then protect the worksheet (tools|Protection|protect sheet). But don't supply a
password.



kanti44 wrote:

Greetings
How can I hide and protect formulas in a worksheet that I want to share with
other users but don't want to have to use a password?
Thanks a bunch!
Kant44


--

Dave Peterson