View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Von Shean Von Shean is offline
external usenet poster
 
Posts: 17
Default how to detect if user has a dialogbox open

My timer macro reads valus from a workbook on one instance of excel and
updates another workbook in another instance of excel.
Sometimes data is large so i turn off screen updating on the recieveing
workbook.
When the user opens a dialogbox in one excel and the macro is running, I get
a ScreenUpdating failed error.
This also happens when the user is editing a cell and the macro runs.

Is there anyway i can detect an open dialogbox ??