VBE Code Windows Maximize on workbook open slowing performance

**Gingermuppet** · 12-01-2014, 10:01 AM

Apologies in advance for the Noob question but this one has me stumped.

I am writing some code that opens and processes workbooks. It all works fine, however I have noticed that the VBE maximises the module code windows one at a time and slows the processing of large ammounts of files.

I have not come accross this before and wondered if anyone could shed some light on something I need to tun off in the Application object or even in windows.

I have the usual Application.EnableEvents, ScreenUpdating and calculations set to false/manual.

Many thanks in advance for your help gang!

**:) Sixthsense :)** · 12-01-2014, 10:04 AM

Check the this workbook code module or Sheet Code Module.

There must be Workbook_Open event or Sheet_Activate event which runs when the workbook get opened

**Gingermuppet** · 12-01-2014, 04:58 PM

Nope I have no workbook_open or sheet_activate/deactivate selection change etc etc.

I do have some macros linked to active x objects. Could that be doing it?

Its the Visual Basic Editor thats the problem, its so strange each module's code window maximizes in the editor. I keep searching the Internet but with no luck.

**:) Sixthsense :)** · 12-02-2014, 01:08 AM

Sometimes it happens when some of the files are added in the Excel Startup or Addin also will cause this issue.

So check the both (i.e.) Automatic Startup and Addins areas