Format "unlocked" cells in a protected sheet

[Tim Oakley]

Hey thanks for looking ... I work with some idiots and we
have a unified timecard in excel. Anyways I have
streamlined the worksheets and would like to protect my
cells (formulas) from their reoccurring "whoops". Is
there anyway to format (fill with color) a cell which is
unlocked but in a protected sheet. I.E. some cells I
want to make protected while leaving others fully
functional. Thanks Again -- TIM

 

[Kieran]

Tom

I accomplish this by protecting the cells I need and setting the enabl
selection property.

The following lines do this;

ActiveSheet.Protect userinterfaceonly:=True
ActiveSheet.EnableSelection = xlUnlockedCells

As far as the cell colours are concerned, the users can't select the
it may be redundant setting them up

 

[Guest]

Kieran ...
Sorry to bother you again but I am not that familar
with what you are talking about. What do I do with the
"following lines do this"

 

[Guest]

Nevermind, holy cow I figured it out. Thanks for the
info.