Macros assigned to Menu Items
 

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

Macros assigned to Menu Items
 

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

On Sep 17, 2:44*pm, Techtrainer
wrote:
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

Macros assigned to Menu Items
 

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


"Techtrainer" wrote in message
...
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