Saving Fomulas only

[Guest]

Can I save my document so that other users can edit anything they want EXCEPT the formulas?

 

[mudraker]

You would need to protect your sheet

select all cells on the sheet that you do not want to lock
Press Ctrl & 1 keys
select protection tab
remove tick from locked check box
press ok

from tools menu select protection, protect sheet

or if you have only a few formulas then
select all cells
Press Ctrl & 1 keys
select protection tab
remove tick from locked check box
press ok
select all cells on the sheet that you want to protect
Press Ctrl & 1 keys
select protection tab
remove tick from locked check box
press o

 

[DDM]

TML, yes; use worksheet protection.

First, select the cells you want people to be able to edit. Right-click them
and select Format Cells > Protection; uncheck Locked, then OK.

Now protect the worksheet. Tools > Protection > Protect Sheet.

Users will be able to navigate and edit the cells you don't protect, but
won't be able to edit protected cells (which should be the ones with your
formulas in them).
--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

Can I save my document so that other users can edit anything they want

EXCEPT the formulas?