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.
Topics:
computers,
programming,
office,
programs,
code,
program,
application,
coding,
Microsoft,
codes,
applications,
problems,
basic,
problem,
spreadsheets,
visual,
exel,
VBA,
debug,
debugging
Using Fluther
or