ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Workbooks.Open (https://www.excelbanter.com/excel-programming/384595-workbooks-open.html)

[email protected]

Workbooks.Open
 
Is there a parameter that I can pass to auto enable the macros of an
Excel spreadsheet that I'm opening with Workbooks.Open?


Dave Peterson

Workbooks.Open
 
I'm not sure I understand.

If you're code is using workbook_open to open another file, then the macros in
that workbook about to be opened will be enabled.

If the user chooses not to allow macros to run, then your workbook_open event
won't even run. This choice is a security setting that each user has to set.



wrote:

Is there a parameter that I can pass to auto enable the macros of an
Excel spreadsheet that I'm opening with Workbooks.Open?


--

Dave Peterson


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

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