|
Workbook Menu screen tips?
Hi,
When you hover over a toolbar button a screen tip (yellow box that appears when you hover over a command button) is visible. Is it possible to get this to happen on custom worksheet menus? Can you get something to appear on the status bar when you hover over the menu item? Any comments will be appreciated. Sean |
Workbook Menu screen tips?
Hi Sean
If you create the button with code you can use the Caption With .Controls.Add(Type:=msoControlButton) .Caption = "Delete the ToolBar" .FaceId = 72 .OnAction = "DeleteToolBar" End With See http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Excel http://www.j-walk.com/ss/excel/tips/tip53.htm Creating Custom Menus (John Walkenbach) TIP http://www.erlandsendata.no/english/...oadcommandbars Ole P. Erlandsen's Web Site (Example workbooks) -- Regards Ron de Bruin http://www.rondebruin.nl "Sean" wrote in message ... Hi, When you hover over a toolbar button a screen tip (yellow box that appears when you hover over a command button) is visible. Is it possible to get this to happen on custom worksheet menus? Can you get something to appear on the status bar when you hover over the menu item? Any comments will be appreciated. Sean |
Workbook Menu screen tips?
Thanks Ron,
I am trying to find out if there is a similar thing for a Menu item, not a button. Sean "Ron de Bruin" wrote in message ... Hi Sean If you create the button with code you can use the Caption With .Controls.Add(Type:=msoControlButton) .Caption = "Delete the ToolBar" .FaceId = 72 .OnAction = "DeleteToolBar" End With See http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Excel http://www.j-walk.com/ss/excel/tips/tip53.htm Creating Custom Menus (John Walkenbach) TIP http://www.erlandsendata.no/english/...oadcommandbars Ole P. Erlandsen's Web Site (Example workbooks) -- Regards Ron de Bruin http://www.rondebruin.nl "Sean" wrote in message ... Hi, When you hover over a toolbar button a screen tip (yellow box that appears when you hover over a command button) is visible. Is it possible to get this to happen on custom worksheet menus? Can you get something to appear on the status bar when you hover over the menu item? Any comments will be appreciated. Sean |
Workbook Menu screen tips?
Hi Sean
Sorry, use .TooltipText = "your text" -- Regards Ron de Bruin http://www.rondebruin.nl "Sean" wrote in message ... Thanks Ron, I am trying to find out if there is a similar thing for a Menu item, not a button. Sean "Ron de Bruin" wrote in message ... Hi Sean If you create the button with code you can use the Caption With .Controls.Add(Type:=msoControlButton) .Caption = "Delete the ToolBar" .FaceId = 72 .OnAction = "DeleteToolBar" End With See http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Excel http://www.j-walk.com/ss/excel/tips/tip53.htm Creating Custom Menus (John Walkenbach) TIP http://www.erlandsendata.no/english/...oadcommandbars Ole P. Erlandsen's Web Site (Example workbooks) -- Regards Ron de Bruin http://www.rondebruin.nl "Sean" wrote in message ... Hi, When you hover over a toolbar button a screen tip (yellow box that appears when you hover over a command button) is visible. Is it possible to get this to happen on custom worksheet menus? Can you get something to appear on the status bar when you hover over the menu item? Any comments will be appreciated. Sean |
Workbook Menu screen tips?
Ron,
Thanks again, but these are all for toolbars and not menu's. Is there a similar command for menus? Sean "Ron de Bruin" wrote in message ... Hi Sean Sorry, use .TooltipText = "your text" -- Regards Ron de Bruin http://www.rondebruin.nl "Sean" wrote in message ... Thanks Ron, I am trying to find out if there is a similar thing for a Menu item, not a button. Sean "Ron de Bruin" wrote in message ... Hi Sean If you create the button with code you can use the Caption With .Controls.Add(Type:=msoControlButton) .Caption = "Delete the ToolBar" .FaceId = 72 .OnAction = "DeleteToolBar" End With See http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Excel http://www.j-walk.com/ss/excel/tips/tip53.htm Creating Custom Menus (John Walkenbach) TIP http://www.erlandsendata.no/english/...oadcommandbars Ole P. Erlandsen's Web Site (Example workbooks) -- Regards Ron de Bruin http://www.rondebruin.nl "Sean" wrote in message ... Hi, When you hover over a toolbar button a screen tip (yellow box that appears when you hover over a command button) is visible. Is it possible to get this to happen on custom worksheet menus? Can you get something to appear on the status bar when you hover over the menu item? Any comments will be appreciated. Sean |
Workbook Menu screen tips?
Hi Hi Sean
It is working if you add a new menubar but not for a menu item you add to a original menu Never try this. When I have time I see if it is possible. Sub MakeMenuBar() On Error Resume Next Application.CommandBars("MyMenuBar").Delete On Error GoTo 0 With Application.CommandBars.Add(Name:="myMenuBar", Position:=msoBarTop, _ MenuBar:=True) With .Controls.Add(Type:=msoControlPopup) .Caption = "Click me" .TooltipText = "your text 1" .OnAction = "MenuBarMacro" End With With .Controls.Add(Type:=msoControlPopup) .BeginGroup = True .Caption = "Delete the MenuBar" .TooltipText = "your text 2" .OnAction = "DeleteMenuBar" End With .Visible = True End With End Sub Sub MenuBarMacro() MsgBox "Hi" End Sub Sub DeleteMenuBar() On Error Resume Next Application.CommandBars("MyMenuBar").Delete On Error GoTo 0 End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Sean" wrote in message ... Ron, Thanks again, but these are all for toolbars and not menu's. Is there a similar command for menus? Sean "Ron de Bruin" wrote in message ... Hi Sean Sorry, use .TooltipText = "your text" -- Regards Ron de Bruin http://www.rondebruin.nl "Sean" wrote in message ... Thanks Ron, I am trying to find out if there is a similar thing for a Menu item, not a button. Sean "Ron de Bruin" wrote in message ... Hi Sean If you create the button with code you can use the Caption With .Controls.Add(Type:=msoControlButton) .Caption = "Delete the ToolBar" .FaceId = 72 .OnAction = "DeleteToolBar" End With See http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Excel http://www.j-walk.com/ss/excel/tips/tip53.htm Creating Custom Menus (John Walkenbach) TIP http://www.erlandsendata.no/english/...oadcommandbars Ole P. Erlandsen's Web Site (Example workbooks) -- Regards Ron de Bruin http://www.rondebruin.nl "Sean" wrote in message ... Hi, When you hover over a toolbar button a screen tip (yellow box that appears when you hover over a command button) is visible. Is it possible to get this to happen on custom worksheet menus? Can you get something to appear on the status bar when you hover over the menu item? Any comments will be appreciated. Sean |
| All times are GMT +1. The time now is 10:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com