How can I disable macros after the initial open?
I'm sure that there will be a more elegant solution to this but, how about
setting a global variable when the macro runs first which you use as a flag
to by-pass subsequent running of any macros i.e. flag = false then
If flag then
do something
else
endif
"Troy" wrote:
I have created an excel template with macros in Excel 2003. The template
works great. I am trying to figure out how to automatically disable the
macros after the initial open and save of the template. I tried to open the
xls file after I did a test run and the macros were still active. How can I
fix this?
|