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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open workbook without running Workbook_Open Event 4
Macro codes automatically opens when opening a excel file 4
Excel 2000 shuts down w/o error msg when opening Outlook 03 email 3
Lose macros before saving 4
Force Macro Enable 3
Can't open excel file with macros after installing Antispyware 1
It takes two clicks to shut down Excel 9
Changing macro security causes VBA code to fail 3

Back
Top