Disable Macros on workbooks.open

Re: Disable Macros on workbooks.open

The only way to prevent it from running is to actually go into the other workbook and comment out the code or delete the code.

The idea of having a macro run in order to disable macros seems a counter-intuitive to me. I'm sure that can't be done.

Re: Disable Macros on workbooks.open

Maybe a fix would be to run macros and trap their execution by event and cross check with the WorkStation opperator that yes these codes are to run or not and from taht question handle the responce correctley

Does that sound like something that would be good for You?

jiuk

Re: Disable Macros on workbooks.open

if opening the workbook read only ALLWAYS means the workbook.open macro should not run then try with the following line as the first line in that macro.
else you might want to "ask the user" if the macro shud be run if readonly = yes

If  ActiveWorkbook.ReadOnly Then exit sub

Re: Disable Macros on workbooks.open

If it is only the data that you want, then this article describes how to extract data from a workbook without opening it (and therefore without the macro issue)

http://www.ozgrid.com/VBA/ExtractFromClosedWorkbook.htm

Re: Disable Macros on workbooks.open

Use Workbook_Open Event instead

Re: Disable Macros on workbooks.open

Even though this is an old post, I thought I would update it with a better solution since I stumbled upon this thread from a Google search for this very topic. In my case I wrote an VBA routine that automatically opened multiple workbooks all with VBA in them. It would have been impractical to open all of the target workbooks ahead of time to edit the VBA.

The solution is simply to use

application.enableevents = False

right before you open the target workbook. It is also very important to use

application.enableevents = True

immediately after.