Opening .xls that runs macro on open

[PiB311]

Hello everyone.

I have inherited some files that now need to optimize some vba, but when I
open the file, it runs some code and then closes the file. I am trying to
figure out how to get around running the program on open.

Any help would be great. I have never coded an on open event in excel so my
scope is limited for this.

 

[Please Help]

When the file opens, on the Security Warning, click on "Disable Macros",
instead of "Enable Macros". That should help you from running the open
macro.

 

[Gord Dibben]

Set Security to high before opening.

Or hold down Shift key when opening.


Gord Dibben MS Excel MVP

 

[PiB311]

Thank you! This worked perfectly.

Please Help, your suggestion would have worked but the window is not active
on open, and just runs the function. Setting security high worked like a
charm.

Thanks again everyone!