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.