Need to limit the range of cells affected by code

[Rednecknerd]

When I click on a cell or double click on a cell that is already selected it changes the fill color.
That part works great.

But how do I limit it to the range B2:L30 ?
Or columns B:L ?

Either one works fine for me.

Thanks in advance for the help.

[Debraj Roy]

Enclose your old code within a IF block..

Please Login or Register  to view this content.

project tracking.xlsm

[Rednecknerd]

Thanks, that is perfect. Rep added.