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

[Michael]

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