D Dave Peterson Mar 27, 2004 #2 If you lock the cells and protect the sheet, you can do this. Ctrl-A (twice if you're running xl2003) to select all the cells. Edit|Goto|Special|Formulas Format|Cells|Protection tab|Locked Unlock the cells that require changes. Tools|Protection|protect sheet. Give it a nice password. That said, worksheet protection is very weak. There's code posted here every day/week that would unprotect the worksheet. ======= The default "lockedness" of a cell is locked. You may not need to change the formula cells--but it doesn't hurt.
If you lock the cells and protect the sheet, you can do this. Ctrl-A (twice if you're running xl2003) to select all the cells. Edit|Goto|Special|Formulas Format|Cells|Protection tab|Locked Unlock the cells that require changes. Tools|Protection|protect sheet. Give it a nice password. That said, worksheet protection is very weak. There's code posted here every day/week that would unprotect the worksheet. ======= The default "lockedness" of a cell is locked. You may not need to change the formula cells--but it doesn't hurt.
