In Visual Basic for Applications, is it possible to capture a program initializing and stop it, so it doesn't inturrupt YOUR code?
A spreadsheet formatter that I made for the department opens and closes Excel spreadsheets in the backround. If someone opens Excel while the macro is running, it stalls the entire program. I need a way to sense Excel opening, then stop it, preferably with a message box saying what just happened.
This question is in the General Section. Responses must be helpful and on-topic.