Workbook_Open event crashes Excel?

[Aland2929]

When I open the file, Excel crashes, reboots & repairs the file. It then highlights the line: Worksheets("Calculator").Activate. I have a sheet named "Calculator"? I have tried deleting the sheet and inserting a new one but still have the same problem?

Thanks in advance.

Please Login or Register  to view this content.

[Aland2929]

When I step through the code I receive this error message: "Run-time error - 32809; Application-defined or object-defined error"

[JazzKult]

Just a wild guess but perhaps the file is corrupt? Have you tried copying the code to a new file and testing if it works?

[romperstomper]

That error number sounds like a problem with activex caused by the December updates. Does your workbook use ActiveX controls?

[Aland2929]

Thank you for your reply. I was using ActiveX controls but have deleted them and the code
associated with the controls. When I open the file the run-time error is 57121? Should I avoid using ActiveX controls and could the problem be with the User forms?
Thanks in advance

[romperstomper]

Generally speaking, yes avoid activex if you can. In my experience, once you have a workbook like that, you have to recreate the sheet(s) that had the control(s). Simply removing the controls and code doesn't work.

[Aland2929]

Once again, thanks very much for your reply. I will delete the sheet & re-create another one. Hopefully that works.