Excel shuts down, macros enabled, Workbook_Open code exists

[PIMotion]

I have MSOffice 2007 installed with latest patches. Previously, even with
Excel 2000 on same machine this behavior occurred.

Situation is: the simpliest XLS (97-2003 format) you can imagine - as in a
blank sheet - no formulas or formatting. Code exists in
ThisWorkbook.Workbook_Open event procedure. Even if just one lonely comment
character exists within the Workbook_Open event, Excel shuts down when macros
are enabled. Using just the Excel installation, no add-ins or templates
modified, added, deleted, manipulated. Permission exists to all folders.

Would appreciate suggestions for cause and remedy. Thanks!

 

[Simon Murphy]

Sounds like a bad add-in - they will survive the move from 2000 to 2007.
Check your COM add-ins in particular either via the registry or via the
blob.

Cheers
Simon
Excel development website: www.codematic.net

 

[PIMotion]

Thanks for the tip Simon. Turns out this problem behavior was resolved when
the afflicted server's OU policy was updated to exclude Excel. Or something
along those lines.