Philcjr
07-21-2005, 06:53 AM
All,
I am currently working on some code in which "file (1)" will open another excel file "file (2)" and copy its contents from multiple worksheets and past the data onto one sheet in "file (1)".
I need to know how to "disable" the macros when "File(2)" opens from the execution of the code in "File(1)"
Thanks,
Phil
I am currently working on some code in which "file (1)" will open another excel file "file (2)" and copy its contents from multiple worksheets and past the data onto one sheet in "file (1)".
I need to know how to "disable" the macros when "File(2)" opens from the execution of the code in "File(1)"
Thanks,
Phil