You can select which cells to lock and then enable worksheet protection.
By default all cells on a sheet are locked when sheet protection is enabled.
Hit CRTL + A(twice for 2003 users) to select all cells.
Format>Cells>Protection. Uncheck "locked" and OK out.
Now select those formula cells and Format>Cells>Protection. Check "locked".
Ok out.
Now Tools>Protection>Protect Sheet.
Tip: Tools>Customize>Format. Scroll down to the Padlock(lock cells) icon.
Drag to your Toolbar.
Saves a few steps when selecting cells to be locked.
Gord Dibben Excel MVP
