Thread: Hiding Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Hiding Formulas

Hi Stan

You need to unprotect the cells, that you want to enter data into before you
protect your sheet.

In Excel 2000:
Select the cells that you want to enter data into. Format Cells
Protection Unmark "Locked" OK

Now you can protect your sheet and still enter data.

Regards

Per

"Stan W." skrev i en meddelelse
...
In Excel 2003 is there a way of entering data after I have hidden the
formulas and protected the sheet?
I do not wish to share the formulas with other users.

Thanks
Stan W.