Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Workbook_Open macro
Hi everyone,
I am opening one workbook from another using this command: Workbooks.Open(wbkname) but when wbkname opens it runs the Workbook_Open subroutine in the ThisWorkbook section. Is there a way I can prevent it from running this code? I am running XP and Excel 2003. TIA big t |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Workbook_Open macro
Hi
not tested but try: application.enableevents=false Workbooks.Open(wbkname) application.enableevents=true -- Regards Frank Kabel Frankfurt, Germany "big t" schrieb im Newsbeitrag ... Hi everyone, I am opening one workbook from another using this command: Workbooks.Open(wbkname) but when wbkname opens it runs the Workbook_Open subroutine in the ThisWorkbook section. Is there a way I can prevent it from running this code? I am running XP and Excel 2003. TIA big t |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Workbook_Open macro
Thanks Frank, that worked a treat!
cheers big t "Frank Kabel" wrote: Hi not tested but try: application.enableevents=false Workbooks.Open(wbkname) application.enableevents=true -- Regards Frank Kabel Frankfurt, Germany "big t" schrieb im Newsbeitrag ... Hi everyone, I am opening one workbook from another using this command: Workbooks.Open(wbkname) but when wbkname opens it runs the Workbook_Open subroutine in the ThisWorkbook section. Is there a way I can prevent it from running this code? I am running XP and Excel 2003. TIA big t |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open macro not running | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Workbook_Open & Macro | Excel Programming | |||
Workbook_Open macro created in Excel 97 problems on MAC | Excel Programming |