ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable Auto Macro (https://www.excelbanter.com/excel-programming/323126-disable-auto-macro.html)

mike_cutting-edge[_2_]

Disable Auto Macro
 
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[_5_]

Disable Auto Macro
 
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


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com