I am running a macro from a file that opens several other files and enters
data into these files. however these files have macros in them.
so essentially i need to keep macros in my main workbook. but disable the
macros in the other workbooks. i cannot rely on users clicking disable
macros.
D
"R. Choate" wrote in message
...
First, just open Excel by itself and disable macros
(ToolsMacrosSecurity, etc.). Then open the workbook with the macros you
don't
want to run.
HTH
--
RMC,CPA
"DMc2005" wrote in message
...
I know how to open a workbook using VBA, but how do i open a workbook and
disable its macros.
D
|