Moving 2003 Custom Menu to Quick Access Toolbar
I have a custom menu in Excel 2003. We are switching to Office 2007 either
this week or next week. I don't want this menu to show up in the Add-Ins tab. Can I move it to the QAT using the following code: If Application.Version = "11.0" Then Set MenuObject = Application.CommandBars(1).Controls.Add(Type:=msoC ontrolPopup, _ Befo=11, Temporary:=True) Else Set MenuObject = Application.CommandBars("Quick Access Toolbar").Controls.Add _ (Type:=msoControlPopup, Temporary:=True) End If If not, I need to know how. TIA -- I am running on Office 2003, unless otherwise stated. |
Moving 2003 Custom Menu to Quick Access Toolbar
Hi Orion
No this is not possible what you want but See http://www.rondebruin.nl/qat.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Orion Cochrane" wrote in message ... I have a custom menu in Excel 2003. We are switching to Office 2007 either this week or next week. I don't want this menu to show up in the Add-Ins tab. Can I move it to the QAT using the following code: If Application.Version = "11.0" Then Set MenuObject = Application.CommandBars(1).Controls.Add(Type:=msoC ontrolPopup, _ Befo=11, Temporary:=True) Else Set MenuObject = Application.CommandBars("Quick Access Toolbar").Controls.Add _ (Type:=msoControlPopup, Temporary:=True) End If If not, I need to know how. TIA -- I am running on Office 2003, unless otherwise stated. |
All times are GMT +1. The time now is 01:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com