I have a macro that automatically goes through a folder of files and processes the data to a summary workbook. This works perfectly and I have Windoze automatically opening the workbook on a specified schedule. The Macro is Auto_run so it is a hands off operation.

Because the macro auto runs, it makes it difficult to manually open it and edit anything without disabling macros

To overcome this I made a "Control Panel" --- A separate workbook that has a checkbox for Yes/No. The first thing my Macro does is open the control panel and look to see if it should run or not. If not then the macro halts and I can make my changes.

Is there any way to detect if a workbook is opened via the task scheduler vs manually double clicking the icon? If so I could eliminate the control panel and if the workbook is opened manually it skips the macro, and if windows opens it the macro runs to completion

Thanks for any insight into this....