Thread: [Solved] Protect formula in cell?
View Single Post
 
Old 05-24-2010, 10:58 AM
markg2 markg2 is offline Windows 7 Office 2007
Expert
  
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default Protect formula in cell?
Office XP

My goal is to protect cells of a spreadsheet that hold formulas so as to not inadvertently overwrite same with data. Help is not helpful. I'm finding how to protect an entire sheet and then allow exclusions or...

The nearest I find is???
  1. In the worksheet, select the cells that contain the formulas that you want to hide.
  2. On the Home tab, in the Cells group, click Format, and then click Format Cells.
  1. On the Protection tab, select the Hidden check box, and then click OK.
Reply With Quote