Saving Fomulas only

T

TML

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

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
 
D

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


TML said:
Can I save my document so that other users can edit anything they want
Click to expand...
EXCEPT the formulas?
 
Top