By default, all cells are lock when you protect the worksheet. Click the
Select All button (the grey square to the left of the 'A' column header and
above the '1'
row header. Unlock all the cells. Then, use CTRL G to display the Goto
dialog and click the Special button. There, select Formulas. That will
select all the cells that have formulas. Finally, change the protection of
the formula cells to locked and protect the sheet.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"lightbulb" wrote in message
...
Is there a way to protect/lock only the cells that contain formulas with a
password?

Thanks!