protecting cells

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

How do you protect cells that contain a formula, and leave
unprotected cells that will have data entered into it?
 
Hi Ed!

Select all cells in the worksheet by pressing the button at the
intersection of rows and column headings.
Format > Cells > Protection
Remove check from "Locked"
OK
Select the cells you want to protect
Format > Cells > Protection
Place check in "Locked"
OK

Tools > Protection > Protect Sheet
Give and confirm password if you want
OK

Note that it's a two stage operation. Format Protection followed by
Tools Protection. To change, you go in reverse.

Also note that the default status for Format Protection is Locked and
Unhidden. In your case you're after a default that allows data entry
anywhere except your chosen formula cells.

Don't forget that by pressing and holding down Ctrl you can select
non-contiguous cells.

I like to highlight the data entry permitted cells in comparison to
no-entry cells. Makes it easier for both me and a user and is one of
my rare uses of color.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Saturday: Bosnia-Herzegovina (Petrovdan); Canada,
Northern Ireland, and Eire (Orangemen's Day); Kiribati (Independence
Day); Malaysia (Birthday of the Yang di-Pertua Negi Pulau Pinang);
Micronesia (Micronesian Day); Sao Tome & Principe (Independence Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
The reply to this post just answered a question I had about protecting
certain cells in a worksheet. It works great, but now my macro's don't
run. I get a debug error and it says they can't execute because the
worksheet is protected. Is there a way around this?
 
Back
Top