Excel commands not available when macro is paused

Question

In Excel 2003, I was able to pause a macro switch to Excel and perform excel functions, then switch back to VB and resume the macro.

In Excel 2007 when I pause a macro and switch to excel, most of the excel functionality does not respond. I can switch between sheets and perform 'browse' type functions, but I cannot change cell values or select functions in the ribbon or change the ribbon tab. I must cancel the macro before Excel will let me perform additional commands. If I try to perform commands while the macro is paused, excel saves them up and when I finally cancel the macro, the commands that did not execute during the pause are then performed.

Any ideas on how to get Excel to respond while a macro is paused?

Answer 1

I found the answer. The macro opened a form which was set to ShowModal=True, which blocked me from using Excel. I changed the form to ShowModal=False and I'm good to go.