How is it possible that excel opens in break mode: how do i stop that

[spurs]

I created an excel workbook years ago that had some code in the this workbook module. General commands for updating ever entry sort of thing. It also calls a password check macro for verification. This has worked well for years.

The workbook was being used by my associate in China. Recently he sent me a copy back to work on and i cant open it the same way anymore.

As soon as the wordbook module runs on opening excel goes into break mode, and the password check macro doesnt run. The error is "cant execute code n break mode"

I can get into the original macro and see that as soon as i execute the first line:

Private Sub Workbook_Open()

in the workbook module, excel goes into break mode

I am suspicious that someone in China has tampered with the file to cause this; I have no idea where to look to resolve it.

I need the worksheet to run macros to calculate properly and i cant get it to do that atm

 

[johnnyL]

post your complete code

 

[johnnyL]

You might also try putting the code into a module instead of a worksheet, if you don't have it that way already.

 

[Michael M]

Press ALT + F11 and look at the Workbook_Open event.
See if there is a line highlighted.
If so, end the macro>>Save>>close and see if it works.
But as @johnnyL as stated, it would help to see the codes

 

[spurs]

I think i have resolved the issue.
The file is a .xls file
When the file was returned to me from our affiliate in China, i opened it directly without saving it first.
When I opened it i first get a request to enable macros which i accept and then i get the following error before the license check happens during the workbook open event

Run time error 1004
Method OnTime of object application failed

To troubleshoot this I saved the file to my system, and being .xls it warns me of compatibility issues on saving which i accept

After saving and reopening from my own system, the run time error does not occur

I assume its a compatibility issue that is resolved by saving first

 

[Joe4]

Assuming that you are not using a really old version of Excel, I would recommend saving as an "xlsm" or "xlsb", which are the Excel file types that allow VBA (since 2003).

By the way, you should update your Profile to show us which version of Office you are using (like you see with mine).
This is often helpful, if people know which version you are running.