I am automating excel to create some report outputs and get an error if users attempt to close excel before it has finished.

Is there some way to prevent users from closing the application till I am ready?

I could simply make excel invisible until complete, but sales team think watching the fields populate is a "feature" .

TIA,

- Craig

"If you're not prepared to be wrong, you will never come up with anything original."
- Sir Ken Robinson