Hi, I have another question, Im new at this and this site has been very very
helpful, wondering if anyone might know....

Is there a way to bring up a UserForm based only on if the user clicks on a
certain colored cell (say ColorIndex = 21)? I dont want to pre-set a range
because it is different from sheet to sheet. (Although setting entire sheet
range(A1:ZZ66500) would be ok i guess). THANKS!