![]() |
a brief explanation of macro, when the cursor is over...
Hello
Is it possible to remind the explanation of macro, that is assigned to a shape; when the cursor is on the shape? Thanks for help |
a brief explanation of macro, when the cursor is over...
You can use the ScreenTip of a hyperlink.
Do not assign the macro to the shape directly. Instead, assign a hyperlink to the shape to take you to some remote cell, say Z100. Put your text in the hyperlink's ScreenTip. Then use the Worksheet_SelectionChange event macro to call your macro when Z100 is selected. What should happen: 1. the user hovers the cursor over the shape 2. the user sees the hyperlink text message 3. the user clicks the shape 4. the cursor jumps to Z100 5. the event macro detects that Z100 has been selected 6. the event macro calls your macro -- Gary''s Student - gsnu200823 "nerohnze" wrote: Hello Is it possible to remind the explanation of macro, that is assigned to a shape; when the cursor is on the shape? Thanks for help |
All times are GMT +1. The time now is 11:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com