Excel Selective Cell Protection

  • Thread starter Thread starter hayasa kite
  • Start date Start date
H

hayasa kite

I am using xl2k AND xl2002 (one at work, the other at home).

I want to selectively protect a couple of different cell ranges on
five different sheets. The file will be made into a template so I
need this code to run everytime the template is used, or everytime the
xls file is re-opened.

I've tried a method, but I have to jump through hoops if I want the
code to remain permanently active.

Can someone help?

Thanks
 
Select the cells you want *unlocked* then "Format Cells->Protection" and
de-select the "Locked" option.
By default the option is "Locked". If you're only trying to lock a
minimal # of cells you may want to select the entire sheet and de-select
the "locked" option, then select the ones you want to lock and repeat
the process (setting them to "Locked").

Note that, as the blurb on the Protection tab says, you have to protect
the sheet for the lock to work.
("Tools-Protection" - and select your choice.)
 
Back
Top