Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Formulas and Being Able to Make Changes
Using Excel 2003
Is there a way to hide the formulas, but still be able to make changes to the cells without the formulas. I followed the below instructions and ALL of the cells on the worksheet are protected. The formulas are hidden, but a user cannot make any changes. Select the range of cells whose formulas you want to hide. You can also select nonadjacent ranges. On the Format menu, click Cells, and then click the Protection tab. Select the Hidden check box. Click OK. On the Tools menu, point to Protection, and then click Protect Sheet. Make sure the Protect worksheet and contents of locked cells check box is selected. ANY help would be greatly appreciated. Thank you, Karen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Formulas | Excel Worksheet Functions | |||
Hiding formulas | Excel Discussion (Misc queries) | |||
Hiding Formulas | Excel Discussion (Misc queries) | |||
Hiding formulas | Excel Discussion (Misc queries) | |||
Hiding formulas | Excel Worksheet Functions |