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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
