What version of excel where you using?

What was the code that did the actual work?

Did you unprotect or protect the worksheet to allow the program to do things
that the user can't (using the userinterfaceonly parm on the .protect
statement)?

Did the cell get locked on that protected sheet?

======
xl2007 changed conditional formatting quite a bit. Before that, all versions of
excel that supported conditional formatting (xl97-xl2003???) were the same.



Nigel wrote:

"Dave Peterson" wrote:

I don't know what (if anything) changed between xl2003 and your previous
version, but this sounds like it's the perfect situation to use
format|conditional formatting. You wouldn't need VBA at all (for the color
change).

Could do that - problem is that then 25 copies of the modified spreadsheet
must be distributed around the country!! That is why I am hoping for a
settings solution.

Also, why did it used to work. And will conditional fromatting work with
older versions of Excel, for the people who haven't upgraded yet?

Nigel

--

Dave Peterson