Open Method disabling Macros

B

Bryan Steffen

Here's my setup. I have one spreadsheet (the "Comprehensive" workbook) that
opens a spreadsheet (1 of 6 "Regional" workbooks), imports in a variety of
data and then closes it out and repeats the routine for all 6 Regional
workbooks.

Workbooks.Open myFileName


In addition, each of the Regional workbooks contains a routine that runs
just _BeforeClose. Currently, when the Comprehensive workbook finishes
importing in the data, it closes the specific Regional workbook. That then
triggers the Workbook_BeforeClose routine, which develops a runtime error
under this nested situation.

What I would like to do is disable the macros when the Comprehensive's
import routine opens the Regional workbook. As I searched for Open Method
for Workbooks, I found no mention of being able to disable macros.

I am operating Excel 2002. All the files are on a local machine. The Excel
Security Level on the machine is set to medium. Anyone have suggestions?
Thanks

Bryan

Bryan D. Steffen
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Macro Alert 2
excel 2003 vs 2007 menu and sheet issues 3
Move some sheets to a new workbook, without macros, and withoutbreaking link btwn Pivot Tables and P 0
Disable "On Open" macro 1
VBA Open Wkbook Disabling Macros 9
Open workbook with unreadable content 0
Can't disable macros in 2nd Excel instance 4
Disable macro's 2

Top