LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Excel 2003/Excel 2007 Add-Ins Do Not Reset after closing files

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

"Barb Reinhardt" wrote:

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



"Harry G" wrote:

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
set Excel 2007 as default to save files in Excel 2003 .xls format John UBS Setting up and Configuration of Excel 1 March 26th 10 02:53 PM
Excel 2003 slow closing files in Vista SP1 Sunny Excel Discussion (Misc queries) 0 June 4th 08 04:42 PM
Excel 2003/2007 Crash when opening/closing files Richard NYC Excel Discussion (Misc queries) 1 October 18th 07 08:22 AM
Excel 2007 xlsx files open as Read-Only in Excel 2003 after Compat Tim Excel Discussion (Misc queries) 1 March 31st 07 11:12 AM
Excel 2007, why is it slow opening files created in Excel 2003? Rick B Excel Discussion (Misc queries) 1 February 19th 07 02:21 AM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"