Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternative Text for shapes
Hi All
I am using shapes and assigning macros to them to use as buttons. I was just wondering if it is possible to get pop up text when you move the cursor over the shapes? (like if you move the cursor over the start menu at the bottom of the screen and linger over one box then a description of the item appears) If so how do I do this or do you have any other suggestions? Thanks heaps Jase |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternative Text for shapes
Jase
The only way I can see to do that is to assign a hyperlink to the shape and use the hyperlink's screen tip. Using a hyperlink will prevent you from running a macro assigned to that shape, however. If you want a workaround, you could make the hyperlink link to a cell that's under the shape, then use the sheet's SelectionChange event to run a macro when that cell is selected (i.e. the shape is clicked). It's not a very nice way to do it for maintainability. Let me know if you're interested in that. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Jase" wrote in message ... Hi All I am using shapes and assigning macros to them to use as buttons. I was just wondering if it is possible to get pop up text when you move the cursor over the shapes? (like if you move the cursor over the start menu at the bottom of the screen and linger over one box then a description of the item appears) If so how do I do this or do you have any other suggestions? Thanks heaps Jase |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
alternative coordinates for creating shapes | Excel Discussion (Misc queries) | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
Text on shapes | Excel Programming |