View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Orion Cochrane Orion Cochrane is offline
external usenet poster
 
Posts: 119
Default 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.