Frank-

The Selection_Change event sounds like the way to go...

How would I define the range and how would the "reprotection" be code
in?

Sorry to be such a bother..

--
jpendegraf

-----------------------------------------------------------------------
jpendegraft's Profile: http://www.excelforum.com/member.php...nfo&userid=570
View this thread: http://www.excelforum.com/showthread.php?threadid=26175