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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Formulas and Being Able to Make Changes
To hide formulas but to allow data
--Select the cells in which you want users to enter data, then go to FormatCellsProtection tab and uncheck 'Lock'. --Select the formulas you want to be hidden. Go to Format - Cells - Protection and select Hidden. --From Tools ProtectionProtect Sheet. This will allow users to enter data, but not change or see the formulas If this post helps click Yes --------------- Jacob Skaria "Karen" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Formulas and Being Able to Make Changes
Thank you so much for your help.
Have a great day, Karen "Jacob Skaria" wrote: To hide formulas but to allow data --Select the cells in which you want users to enter data, then go to FormatCellsProtection tab and uncheck 'Lock'. --Select the formulas you want to be hidden. Go to Format - Cells - Protection and select Hidden. --From Tools ProtectionProtect Sheet. This will allow users to enter data, but not change or see the formulas If this post helps click Yes --------------- Jacob Skaria "Karen" wrote: 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 |
Reply |
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 |