Topic: Disabling macros when opening workbook from VB @ AskWoody

Disabling macros when opening workbook from VB
Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Disabling macros when opening workbook from VB
- This topic has 16 replies, 3 voices, and was last updated 15 years, 5 months ago.
Author

Topic
New Reply

WSah724
AskWoody Lounger

January 14, 2010 at 2:42 pm #465789

I am running a macro from Excel that opens other Excel workbooks with Workbooks.Open. Some of those workbooks have macros that automatically run when opened, and that is causing a problem. Does anyone know how to disable the macros of a workbook being opened from VB. When manually opening, one gets a prompt to Enable Macros or Disable Macros, but what is the equivalent in VB?

Reply | Quote

Viewing 15 reply threads
Author

Replies
- WSah724
  AskWoody Lounger
  
  January 14, 2010 at 2:42 pm #1199547
  
  I am running a macro from Excel that opens other Excel workbooks with Workbooks.Open. Some of those workbooks have macros that automatically run when opened, and that is causing a problem. Does anyone know how to disable the macros of a workbook being opened from VB. When manually opening, one gets a prompt to Enable Macros or Disable Macros, but what is the equivalent in VB?
  
  Reply | Quote
- WSah724
  AskWoody Lounger
  
  January 14, 2010 at 2:42 pm #1199972
  
  I am running a macro from Excel that opens other Excel workbooks with Workbooks.Open. Some of those workbooks have macros that automatically run when opened, and that is causing a problem. Does anyone know how to disable the macros of a workbook being opened from VB. When manually opening, one gets a prompt to Enable Macros or Disable Macros, but what is the equivalent in VB?
  
  Reply | Quote
- WSah724
  AskWoody Lounger
  
  January 14, 2010 at 2:42 pm #1200728
  
  I am running a macro from Excel that opens other Excel workbooks with Workbooks.Open. Some of those workbooks have macros that automatically run when opened, and that is causing a problem. Does anyone know how to disable the macros of a workbook being opened from VB. When manually opening, one gets a prompt to Enable Macros or Disable Macros, but what is the equivalent in VB?
  
  Reply | Quote
- WSah724
  AskWoody Lounger
  
  January 14, 2010 at 2:42 pm #1201647
  
  I am running a macro from Excel that opens other Excel workbooks with Workbooks.Open. Some of those workbooks have macros that automatically run when opened, and that is causing a problem. Does anyone know how to disable the macros of a workbook being opened from VB. When manually opening, one gets a prompt to Enable Macros or Disable Macros, but what is the equivalent in VB?
  
  Reply | Quote
- WSah724
  AskWoody Lounger
  
  January 14, 2010 at 2:42 pm #1202418
  
  I am running a macro from Excel that opens other Excel workbooks with Workbooks.Open. Some of those workbooks have macros that automatically run when opened, and that is causing a problem. Does anyone know how to disable the macros of a workbook being opened from VB. When manually opening, one gets a prompt to Enable Macros or Disable Macros, but what is the equivalent in VB?
  
  Reply | Quote
- WSah724
  AskWoody Lounger
  
  January 14, 2010 at 2:42 pm #1203297
  
  I am running a macro from Excel that opens other Excel workbooks with Workbooks.Open. Some of those workbooks have macros that automatically run when opened, and that is causing a problem. Does anyone know how to disable the macros of a workbook being opened from VB. When manually opening, one gets a prompt to Enable Macros or Disable Macros, but what is the equivalent in VB?
  
  Reply | Quote
- WSah724
  AskWoody Lounger
  
  January 14, 2010 at 2:42 pm #1204132
  
  I am running a macro from Excel that opens other Excel workbooks with Workbooks.Open. Some of those workbooks have macros that automatically run when opened, and that is causing a problem. Does anyone know how to disable the macros of a workbook being opened from VB. When manually opening, one gets a prompt to Enable Macros or Disable Macros, but what is the equivalent in VB?
  
  Reply | Quote
- RetiredGeek
  AskWoody_MVP
  
  January 14, 2010 at 7:23 pm #1198474
  
  I just ran a quick test to refresh my memory and Auto_Open macros do Not run when the workbook is
  opened by Workbook.open.
  
  Do you have some other types of auto execute macros, perhaps triggered by an event?
  
  RG
  
  May the Forces of good computing be with you!
  
  RG
  
  PowerShell & VBA Rule!
  Computer Specs
  
  Reply | Quote
- RetiredGeek
  AskWoody_MVP
  
  January 14, 2010 at 7:23 pm #1199686
  
  I just ran a quick test to refresh my memory and Auto_Open macros do Not run when the workbook is
  opened by Workbook.open.
  
  Do you have some other types of auto execute macros, perhaps triggered by an event?
  
  RG
  
  May the Forces of good computing be with you!
  
  RG
  
  PowerShell & VBA Rule!
  Computer Specs
  
  Reply | Quote
- RetiredGeek
  AskWoody_MVP
  
  January 14, 2010 at 7:23 pm #1200069
  
  I just ran a quick test to refresh my memory and Auto_Open macros do Not run when the workbook is
  opened by Workbook.open.
  
  Do you have some other types of auto execute macros, perhaps triggered by an event?
  
  RG
  
  May the Forces of good computing be with you!
  
  RG
  
  PowerShell & VBA Rule!
  Computer Specs
  
  Reply | Quote
- RetiredGeek
  AskWoody_MVP
  
  January 14, 2010 at 7:23 pm #1200796
  
  I just ran a quick test to refresh my memory and Auto_Open macros do Not run when the workbook is
  opened by Workbook.open.
  
  Do you have some other types of auto execute macros, perhaps triggered by an event?
  
  RG
  
  May the Forces of good computing be with you!
  
  RG
  
  PowerShell & VBA Rule!
  Computer Specs
  
  Reply | Quote
- RetiredGeek
  AskWoody_MVP
  
  January 14, 2010 at 7:23 pm #1201715
  
  I just ran a quick test to refresh my memory and Auto_Open macros do Not run when the workbook is
  opened by Workbook.open.
  
  Do you have some other types of auto execute macros, perhaps triggered by an event?
  
  RG
  
  May the Forces of good computing be with you!
  
  RG
  
  PowerShell & VBA Rule!
  Computer Specs
  
  Reply | Quote
- RetiredGeek
  AskWoody_MVP
  
  January 14, 2010 at 7:23 pm #1202486
  
  I just ran a quick test to refresh my memory and Auto_Open macros do Not run when the workbook is
  opened by Workbook.open.
  
  Do you have some other types of auto execute macros, perhaps triggered by an event?
  
  RG
  
  May the Forces of good computing be with you!
  
  RG
  
  PowerShell & VBA Rule!
  Computer Specs
  
  Reply | Quote
- RetiredGeek
  AskWoody_MVP
  
  January 14, 2010 at 7:23 pm #1203395
  
  I just ran a quick test to refresh my memory and Auto_Open macros do Not run when the workbook is
  opened by Workbook.open.
  
  Do you have some other types of auto execute macros, perhaps triggered by an event?
  
  RG
  
  May the Forces of good computing be with you!
  
  RG
  
  PowerShell & VBA Rule!
  Computer Specs
  
  Reply | Quote
- RetiredGeek
  AskWoody_MVP
  
  January 14, 2010 at 7:23 pm #1204230
  
  I just ran a quick test to refresh my memory and Auto_Open macros do Not run when the workbook is
  opened by Workbook.open.
  
  Do you have some other types of auto execute macros, perhaps triggered by an event?
  
  RG
  
  May the Forces of good computing be with you!
  
  RG
  
  PowerShell & VBA Rule!
  Computer Specs
  
  Reply | Quote
- WSpieterse
  AskWoody Lounger
  
  January 15, 2010 at 8:34 am #1204341
  
  To prevent Workbook_Open from running you can put
  Application.EnableEvents=False
  just before the macro opens the file.
  
  DO remember to turn those back on!
  Application.EnableEvents=True
  
  As of Excel 2007, you can disable macros:
  
  application.AutomationSecurity=msoAutomationSecurityForceDisable
  
  This also needs to be reset to the previous setting. Look in VBA help for more information
  
  Reply | Quote
Viewing 15 reply threads

Reply To: Disabling macros when opening workbook from VB
You can use BBCodes to format your content.
Your account can't use all available BBCodes, they will be stripped before saving.

Your information:
Name (required):

Mail (will not be published) (required):

Website:

Cancel

Plus Membership

Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.

AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.

Welcome to our unique respite from the madness.

It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.

Disabling macros when opening workbook from VB

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Key Links

Remembering Woody

Disabling macros when opening workbook from VB

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Login and Registration

Key Links

Remembering Woody