Saving formulas in a worksheet so that.....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Look up 'protect' in help and I'm sure that you will work your way through
what you need.

Regards,

OssieMac
 
ok...because i tried the sheet protect thing and that doesnt seem to let me
enter anything in the cells.
 
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.
 
Back
Top