Looking for sample code that would allow me to kill any modal dialog present in Excel
 

Hi there,

Looking for sample code that would allow me to kill any modal dialog present
in Excel while executing my macro (my macro refreshes some PivotTables every
X seconds using the Timer object). Assuming PivotTable refresh failed at
some point a modal dialog is present hence Refresh can not occur again and
eventually Excel shuts down.

What I want is sample code to first check if there is any modal dialog
present and then do whatever code I need to do.

Thanks
Michael