Hi,

I am trying to do the following:

Making a MouseMove event for a sheet. When the cursor reaches the top of a sheet, i would like to show my personal commandbar. This is similar to the "Auto-Hide Taskbar" option of the taskbar below your screen (with "Start").

Does anyone know IF this is possible, and how it would be done?

thanks
max

Hi Max,

If it´s question about one sheet you can place an image object to the sheet.
Set its properties:
Top=0
Left=0
Width=12288
Height=1
BackStyle=Transparent
BorderStyle=None
OnMouseMoveEvent=Application.CommandBars("Your commandbar").Visible = True

-vemaju

thats a great idea! thanks alot vemaju. Is it also possible to run a routine when the user moves the cursor at a specific spot on the Worksheet, i.e. a Sheetx_MouseMove(X as integer, Y as integer) ?

thanks
-Max

Hi

It seems that there is no way to trigger MouseMove event.
I checked API calls too.

-vemaju

ok thank you for your help vemaju