Format "unlocked" cells in a protected sheet

  • Thread starter Thread starter Tim Oakley
  • Start date Start date
T

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
 
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
 
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"
 
Back
Top