Scheduled Programs - Personal Macro Workbook Dialog Stalling my Program

Hello-

I've automated a few different vba procedures by setting up xlsm templates (workbook_open event). I'm opening these from the task scheduler. It's difficult to determine when these tasks will end due to changing data sets (one is from a web api that pulls over 100,000 records and this data set changes).

Anyway, if one of these templates is opened before the preceding template has executed the Application.Quit method a "Read Only" dialog for the Personal Macro Workbook appears and my program stalls out until I can click it. Wondering if there is a programmatic way to suppress the Personal Macro Workbook dialog.

Thanks for the help.

It's not being changed. When my first task executes it opens the application with my personal macro workbook enabled. When the second task runs it creates a new instance of excel. This is when the dialog shows up saying that my Personal Macro Workbook is read only because it's already "in use" - although I'm not using it at all - in the first application.