Can't open VBA excel workbook

[Adogeb]

Hi,

I have a VBA program that sometimes wouldn't open. When I try to open it, it says "Microsoft Excel has stopped working" and below is the detail of the problem. Please help!

Problem signature:
Problem Event Name: BEX
Application Name: EXCEL.EXE
Application Version: 16.0.11629.20246
Application Timestamp: 5cfadbef
Fault Module Name: unknown
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Offset: 00000000
Exception Code: c0000005
Exception Data: 00000008
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 4105

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

[#2]

Does it allow you to open it if you first disable all macros (in Excel options, trust center, trust center settings) befor eopening the file?

[#3]

@Jan Karel Pieterse Yes, I can open it if i disable macros beforehand.

[#4]

@Adogeb

You need to check the VBA code and find out the causes of the crash.

[#5]

In that caase you can try opening the workbook with macro's enabled but also making sure you prevent the Workbook_Open event like so: https://jkp-ads.com/Articles/preventopenevent.asp
Once open, open the VBA Editor, locate the Workbook_Open event and stert stepping through it until you find the line that causes the crash.

[#6]

OK, thanks,