As opposed to clicking on each cell and seeing if its a formual, can I just protect all the cells on a worksheet that contain formulas?
As opposed to clicking on each cell and seeing if its a formual, can I just protect all the cells on a worksheet that contain formulas?
Last edited by jartzh; 02-17-2012 at 05:05 PM.
Yes, that can be done.
Select the entire sheet, and de-select “Locked” on the Protection tab of Format Cells. Press F5, click Special, select Formulas and OK. Now all the cells with formulas are highlighted. Go back to the Protection tab of Format Cells and select Locked. Turn on protection for the sheet (including a password if you like) and you are all set.
Thanks Canuck Chuck.
That did it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks