VBA Macro stops working after opening the VB Editor

[jpar]

Hello everyone,

any reason how it can be possible, that if I open my excel-file and run the macro, everything is fine. Then if I just open the Visual Basic Editor, close it again and try to run the macro, it fails to work.

It also fails to work if I open the file and have the VB editor already open.

The macro imports data from Urchin, can this effect? Also Im not the original creator of this file and there are private and public subs.

Any help would be greatly appreciated!

Jpar

E: additional info

[Press]

A similar case had happened to me on an old PC because the file is too large.
Test on a different computer if the problem reappears or alternatively in a test reduce the size