No I don't got it. I gave you what you asked for. It is unclear how your
additional information has changed that. The only addendum I would add, is
if the sheet is static, you certainly don't need a macro to do this. Set it
up manually and be done with it.

--
Regards,
Tom Ogilvy

"jobeer" wrote:


These cell have values... is there a way to protect them too?


ok, lets say: I have a table with the days of a month (obtained by
formula).
Some days are weekend or hollidays. These particular cells have a
background fill.
This worksheet is to set holliday periods for employees. So I don't
want to select Christmas or other hollidays, got it?

So these cells with numbers should be protected, but not for edition,
because of the background fill change!

Is this possible?


--
jobeer
------------------------------------------------------------------------
jobeer's Profile: http://www.excelforum.com/member.php...o&userid=32447
View this thread: http://www.excelforum.com/showthread...hreadid=523145