Excel 2007 APPCRASH - Custom Toolbar Code

[codeguru]

I am porting an Excel application from Excel 2000 to Excel 2007 and
encountering problems.

VBA code establishes a custom toolbar, and as the user operates the
application, VBA code tears down the toolbar and rebuilds it.

Though this works okay in Excel 2000, when the code runs in Excel 2007 it
abends with the following information:
Problem signature:
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 12.0.6300.5000
Application Timestamp: 47607042
Fault Module Name: mso.dll
Fault Module Version: 12.0.6213.1000
Fault Module Timestamp: 46eafebf
Exception Code: c0000005
Exception Offset: 00039d73
OS Version: 6.0.6000.2.0.0.256.4
Locale ID: 1033

Additional information about the problem:
LCID: 1033
Brand: Office12Crash
skulcid: 1033

Additional info from the Windows application log shows indicates error 1000.

Specifics are that I am running Office 2007 on Vista - full patches except
Vista SP1.

Any help is appreciated.

 

[Shane Devenshire]

Hi,

First off there are no custom toolbar in 2007 so writing code to make one
will fail. You can create custom ribbons, try googling Ribbon X. However,
ribbon customization is not done via VBA.

Cheers,
Shane

 

[codeguru]

Shane,

Thanks for your reply.

It is a little odd that MS would not provide backward compatibility with a
spreadsheet that works fine in Excel 2003. Even if it isn't fully backward
compatible, I would expect it to trap the problem and provide some sort of
message, rather than throwing a exploding with a generic error 1000.

Indeed, the VBA code to create and populate the toolbar works fine (the
toolbar gets created on the "Add-In" ribbon tab), and it functions fine,
calling appropriate VBA code. The problem happens when the code tears down
and recreates the toolbar.

This isn't stuff I built - I was just asked to remediate it - and Excel
isn't my typical development platform, and I appreciate your help.

Thanks!