PoggiPJ
Active Member
- Joined
- Mar 25, 2008
- Messages
- 330
My user community is mixed among 2003, 2007, 2010, and 2013 (lucky me). The workbook must be passed between and edited by users on all of these platforms, and is always saved in Excel 97-2003 xls format. The workbook is stable in all of the platforms except 2013. There is no identifiable pattern as to when 2013 presents the "Excel is closing, recovering your file..." message. This is a large, but not complicated workbook. No graphs, pivot tables, databases... just lots of tabs, macros and formulas. My only "suspect" at the moment is that (because we still have 2003 users) I cannot yet use the Ribbon to control menus, so I use commands like the following when opening or becoming active..
and then
when closing or switching to a different workbook. This has not been a problem to date because these menus simply appear as Add-Ins and have been working fine. Is there a known conflict between 2013 the the old menu commands or should I be looking elsewhere for the cause?
Most users are on 64bit Win 7, with 32 bit installations of Excel 2007, 2010, or 2013. The 2003 users are of course on Win XP
Code:
MenuBars(xlWorksheet).Reset
'------------------------------------------------------------------------------------
'Add the top-level DEALMAKER TOOLS menu to the Worksheet CommandBar
'------------------------------------------------------------------------------------
Set MenuObject = Application.CommandBars(1). _
Controls.Add(Type:=msoControlPopup, _
Before:=10, _
temporary:=True)
MenuObject.Caption = "ELA Tools"
Code:
MenuBars(xlWorksheet).Reset
Most users are on 64bit Win 7, with 32 bit installations of Excel 2007, 2010, or 2013. The 2003 users are of course on Win XP