VBA code to trigger Auto_Run Macro (Scheduler)

[rlsublime]

I currently have a workbook with multiple tabs and the there is a macro in the tab called "Summary". I am trying to link the macro to a scheduler. Currently, I have a scheduler that will open the file, but I am trying to get the file to open and the macro to run as soon as the file is opened and then have the file close when the macro has run? does anyone what code to use to auto run the macro if the macro is on one tab out of 7 tabs in the workbook?

Thanks

[smuzoen]

You would use the workbook_open event - essentially you can add an excel workbook to windows task scheduler and this will open the workbook. Then in the workbook open event just call the macro

Please Login or Register  to view this content.

This would be place in ThisWorkbook in the VB editor.
Is that what you mean?

[rlsublime]

Yes that worked thanks. I am trying to figure out how to prevent the Enable Macro Security popup from generating. When I disabled it in the Tools>macro security settings, it did not save the change and the box continued to pop up as the file was opened.

Thanks for the help.

[smuzoen]

If you want to disable the pop up from generating and allow the macro to run then set it to Enable All Macros (however consider consequences/potential) for malicious code and tick Trust access to the VBA project object model. If you want to disable pop up and prevent code running then select disable all macros without notification.