running VBA disables all other open workbooks

Good Morning, quick question please.
I have 2 workbooks open with data, no code. Then when I open another workbook and run VBA code from auto_open, it locks all my opened workbook.
Is it possible to stop this behaviour, so that VBA code only pertains to its own workbook, and user can still browse/edit different unrelated workbooks?
Many thanks in advance
jack

Check your auto_open workbook code. If it says "ActiveWorkbook" in your code, it may be confused which book is active.

Consider changing to "ThisWorkbook".

I believe since Excel 2010, when a new workbook is opened, each one is an individually new running instance of Excel. In essence, each workbook is separate from each other.
Make certain each workbook is running in a separate instance of Excel ?

Of course sharing your code would help immensely.

Throwing out a guess here ...

Will your project work if you change :

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hi, no difference.
I tried creating vba project from scratch. Then in module I just bring up empty form using show. And it lock all other opened workbooks.
Must be a setting somewhere, but I don't know enough about it. Many thanks for your help.

Opening a form shouldn't have that effect. There must be something in the code within the form that is causing the error.

I don't know enough about

Please Login or Register  to view this content.

to be able to speak about it. However, you are only
referencing the OLE DB module. Not certain how that would affect anything.

At least you mentioning that the error occurs when you open the form ... that narrows it down a little.

If you use OPTION EXPLICIT at the top of all of your macros, that will help to point out any errors in your code.

If you also have ON ERROR RESUME NEXT in your macros ... comment that line out so your project won't bypass any errors.

If you are familiar with stepping through your code, do that as well. Oftentimes after disabling ON ERROR RESUME NEXT and stepping through your code
will help to pin down the offending line in the code. In case you don't understand "stepping through your code" ...

Please Login or Register  to view this content.

If you are aware of stepping through the code .. I apologize for preaching to the choir.

Providing some error messages will help with this effort.

Any one else want to join in the conversation to help ?

Hi, to make things simpler I started new project, with 1 module that does frm01.show, and 1 blank form frm01 that's being shown. With option explicit. No other code.
Stepping through - loads a form, as soon as form loads - all other previously opened workbooks are frozen. And I can't open any new workbooks.
So is this intended behaviour?

"So is this intended behaviour?" .... No

Sometimes my computer does strange things when I repeatedly open a form in a project I am building. Especially if, while running the project to test it and I use the CTRL / BREAK keys to stop
a macro from running.

The only way I can get around it is to save my work, close everything down and re-boot the computer. Then it runs smoothly again until I use CTRL / BREAK too often again.

It's late here now. About 10 pm.

See what you can get done. I'll check back in the morning.

Cheers

Hi there, got it, problem was with the userform itself - it was set to Modal. Thanks for your help, I should have known this. Cheers.

Ha ! And all along my mind was focused on a corrupt workbook or incorrect syntax.

I'm beating my head against the wall repeating "It's the simple stuff, stupid. It's the simple stuff, stupid."

So glad you got it ironed out.

Cheers mate !