Hi all,

I'm trying to run a code when the mouse pointer comes on a specific range
on, for example, Sheet1. Im trying to run a little macro which shows a
toolbar, when the cursor is on the X, Y ranges of the standard toolbar (when
the cursor moves over the toolbar's position, while the toolbar is not
visible, it makes it visible).

Does anyone know how to do this?

Thanks in advance
Max

Hi
not really possible as there's no event which return the X/Y position
on a spreadsheet. So you'll have to use Windows aPI functions and
CALCULATE the mouse position on your spreadsheet

--
Regards
Frank Kabel
Frankfurt, Germany

"Max Potters" schrieb im Newsbeitrag
...
Hi all,

I'm trying to run a code when the mouse pointer comes on a specific
range
on, for example, Sheet1. Im trying to run a little macro which shows
a
toolbar, when the cursor is on the X, Y ranges of the standard
toolbar (when
the cursor moves over the toolbar's position, while the toolbar is
not
visible, it makes it visible).

Does anyone know how to do this?

Thanks in advance
Max

Max,

Take a look at the RangeFromPoint method in help.

--

HTH

RP

"Max Potters" wrote in message
...
Hi all,

I'm trying to run a code when the mouse pointer comes on a specific range
on, for example, Sheet1. Im trying to run a little macro which shows a
toolbar, when the cursor is on the X, Y ranges of the standard toolbar
(when
the cursor moves over the toolbar's position, while the toolbar is not
visible, it makes it visible).

Does anyone know how to do this?

Thanks in advance
Max

hi,
not really possible to do that.
but you might be able to play tricks.
Put a label control on the range somewhere. you can then
use the label controls mouse move event.

-----Original Message-----
Hi all,

I'm trying to run a code when the mouse pointer comes on
a specific range
on, for example, Sheet1. Im trying to run a little macro
which shows a
toolbar, when the cursor is on the X, Y ranges of the
standard toolbar (when
the cursor moves over the toolbar's position, while the
toolbar is not
visible, it makes it visible).

Does anyone know how to do this?

Thanks in advance
Max


.