I need to disable Auto Macro in order to open a number of spreadsheets using
a macro. These spreadsheets have an Auto Macro that loads info from a server.
Is there a way I can open these spreadsheets with their macros disabled??

to have workbook_open procedures not fi

application.enableevents = false
'open your workbooks
application.enableevents = true



mike_cutting-edge wrote:

I need to disable Auto Macro in order to open a number of spreadsheets using
a macro. These spreadsheets have an Auto Macro that loads info from a server.
Is there a way I can open these spreadsheets with their macros disabled??

--

Dave Peterson