I have a Excel Workbook called "PSC Dashboard" I have created a VBA which contains a running digital clock. In order to keep this running I had to protect the workbook/sheet. I also have a VBA under Microsoft Excel Objects then in "ThisWorkbook" that runs the macro as soon as I open the specific file.
Private Sub Workbook_Open()
The problem occurs anytime I open another Excel Workbook the running Macro "PSC Dashboard" takes over any other Workbook. I want to keep my PSC Dashboard open yet not have it interfere in my non related workbooks I have open.
Solved by C. J. in 19 mins