hi all, probably a quick question but i cant figure it out.....

how do you set the focus to a cell if it is single clicked?

here is my situation. I need to be able to single click on a cell and make
it set the focus as if it were double clicked. the criteria is that the
selection.interior.colorindex = 2 and this color is only in one part of my
spreadsheet. any help would be great, thanks