Excel shuts down, macros enabled, Workbook_Open code exists

  • Thread starter Thread starter PIMotion
  • Start date Start date
P

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!
 
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
 
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.
 
Back
Top