Excel 2003/Excel 2007 Add-Ins Do Not Reset after closing files

[Harry G]

I am running an Excel Workbook in Excel 2007 saved as Excel 97-2003. Before
closing application I have VB to reset Menu Bars.

Code: Application.CommandBars("Worksheet Menu bar").Reset

When I close the application, the Add-Ins are not reset. Is there a
different code for Excel 2007 since the additional Menus are now shown with
the Add-Ins?

Appreciate any help.

Harry G

Thanks.

Harry G

 

[Barb Reinhardt]

I'm not on 2007 yet, but I thought this was replaced by the Ribbons in 2007.
Someone correct me if I'm wrong.

 

[Harry G]

I have this code since Excel 97 and carried the code to Excel 2003 with no
problem until I upgraded to Excel 2007.

Thanks.

Harry G