Run macro when cell is clicked but NOT selected

**Alicita** · 01-31-2011, 08:17 AM

Hi guys!

Is it possible to run a macro when a cell is clicked (with the mouse arrow) but NOT when is selected with, say, the keyboard?

i.e I want to run a macro when A2 is clicked but not when I change my active cell with the keyboard arrows.

thanks

**StephenR** · 01-31-2011, 08:32 AM

Why? Why not use double-click and selection?

**TMS** · 01-31-2011, 08:38 AM

I'm not sure that you can differentiate how the cell has been "accessed".

For example, if you press Enter, the cursor will move down, to the right, or to the next unlocked cell (if the sheet protection is set) depending on your setup. If you press tab, you'll have a similar effect.

If you use the mouse, any cell could have been selected previously. However, pressing F5 (Go To) and putting in a cell address would look the same.

There's no "Mouse Over" event AFAIK.

Regards

**davesexcel** · 01-31-2011, 08:41 AM

It may be best just to place a button on cell A2.
It can be a button, picture,autoshape or even the rectangle from the drawings toolbar.
Right click on the object and select assign macro..

If you use the rectangle...
select the rectangle to draw
press the Alt button and select the cell you want to place it on
click at the top left corner and drag to the bottom right corner of the cell.

This will place the rectangle perfectly in the cell. Right click and assign the macro to it.

**Alicita** · 01-31-2011, 08:41 AM

Mmm.. then i'll change it to double click i suppose

Thank you

**jwright650** · 01-31-2011, 08:44 AM

Can you hide a textbox behind the cell?....you can still arrow through that cell and it would not active the macro, but if you mouse click, it will activate.

EDIT#2:Whoops, Dave already suggested this.....