Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
Macro runs faster when VB code window open | Excel Programming | |||
Macro runs in another workbook if you open simultaneously | Excel Programming | |||
Macro runs upon wkbk open, but no Workbook_Open or Auto_Open Macro | Excel Programming | |||
macro only runs on fresh open of excel? | Excel Programming |