Workbooks.Open

  • Thread starter Thread starter cweaverster
  • Start date Start date
C

cweaverster

Is there a parameter that I can pass to auto enable the macros of an
Excel spreadsheet that I'm opening with 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top