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

Similar Threads

compile error with FaceId 2
Macro will not be assigned to a toolbar button. 0
Add File menu to custom toolbar 4
Send CommandBarControl Tag as Parameter to Another Procedure 1
Excel 2003 Command bars 3
Custom Menu 11
CommandBar and Controls (how to create separate "Sets" of Controls) 4
Can anyone help toolbar struggle 5

Top