Moving 2003 Custom Menu to Quick Access Toolbar

O

Orion Cochrane

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:=msoControlPopup, _
Before:=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top