Macros assigned to Menu Items

[Techtrainer]

In Excel 2003 I created a custom menu with each button on the menu labeled
BOOKKEEPING 2006, BOOKKEEPING 2007, etc. and having a macro assigned to each
one to open the appropriate file
In Excel 2007- Addins tab, the toolbar I created in ver 2003 appears, but I
can't modify the custom toolbar within. I even went back to Excel 2003,
created a macro to open the new file, and added a button to the menu, but it
doesn't update it in version 2007
How can I customize the custom toolbar in Excel 2007 to include my new macro
BOOKKEEPING 2009 for the upcoming year.

I am NOT a VBA programmer
Thanks
BV

 

[paul.robinson]

Hi
Did you delete the old toolbar in 2007? It might be that you are still
seeing the old toolbar.
In the workbook_open sub I have code to remove "MyToolbar" first,
before I then add the same ToolBar. If "MyToolbar" is already there
and you don't delete it first, then a new version of the toolbar won't
be seen.

On Error Resume Next 'Incase it has already been deleted
Set cbWSMenuBar = CommandBars("Worksheet Menu Bar")
cbWSMenuBar.Controls("MyToolbar").Delete

regards
Paul

 

[Bernie Deitrick]

BV,

Excel 2007 uses a different system of toolbars: the Ribbon. See Ron deBruin's site

http://www.rondebruin.nl:80/tips.htm

He has a whole section on ribbon usage.

HTH,
Bernie
MS Excel MVP