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

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

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.

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.

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

Thankyou very much Max!

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

welcome.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"migalow" wrote in message
...

Thankyou very much Max!