Opening .xls that runs macro on open
 

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.

Opening .xls that runs macro on open
 

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.

"PiB311" wrote:

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.

Opening .xls that runs macro on open
 

Set Security to high before opening.

Or hold down Shift key when opening.


Gord Dibben MS Excel MVP

On Mon, 18 May 2009 13:40:10 -0700, PiB311
wrote:

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.

Opening .xls that runs macro on open
 

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!

"Gord Dibben" wrote:

Set Security to high before opening.

Or hold down Shift key when opening.


Gord Dibben MS Excel MVP

On Mon, 18 May 2009 13:40:10 -0700, PiB311
wrote:

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.