Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving formulas in a worksheet so that.....
i am new at this so this may seem simple to some of you. I want to save the
formulas in the worksheet i am doing so that at the end of the day when someone enters the needed information they cant damage any of the formulas or accidentally delete the formulas i have put in.. linda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving formulas in a worksheet so that.....
Look up 'protect' in help and I'm sure that you will work your way through
what you need. Regards, OssieMac "migalow" wrote: i am new at this so this may seem simple to some of you. I want to save the formulas in the worksheet i am doing so that at the end of the day when someone enters the needed information they cant damage any of the formulas or accidentally delete the formulas i have put in.. linda |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving formulas in a worksheet so that.....
ok...because i tried the sheet protect thing and that doesnt seem to let me
enter anything in the cells. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving formulas in a worksheet so that.....
Try it in this sequence to protect only the formula cells in the sheet.
Select the entire sheet, click Format Cells Protection tab. Uncheck "Locked" OK. This "unlocks" all the cells in the sheet. Now press F5 Special Check "Formulas" OK This selects all the formula cells on the sheet at one go. Click Format Cells Protection tab. Check "Locked" OK. If you want to "hide" the formulas as well, check also "Hidden" in the tab before you OK out. Then just apply sheet protection via clicking Tools Protection Protect Sheet password? OK. The above would protect only the formula cells in the sheet. And if you had checked "Hidden" as well earlier, then the formulas cannot be seen in the formula bar when these cells are selected. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "migalow" wrote: ok...because i tried the sheet protect thing and that doesnt seem to let me enter anything in the cells. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving formulas in a worksheet so that.....
Thankyou very much Max! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving formulas in a worksheet so that.....
welcome.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "migalow" wrote in message ... Thankyou very much Max! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving a worksheet | Excel Discussion (Misc queries) | |||
Deleting data in cells while saving formatting & formulas | New Users to Excel | |||
worksheet saving | Excel Discussion (Misc queries) | |||
Saving templates with links and formulas | Excel Discussion (Misc queries) | |||
Saving a Worksheet | Excel Discussion (Misc queries) |