how to detect if user has a dialogbox open

  • Thread starter Thread starter Von Shean
  • Start date Start date
V

Von Shean

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 ??
 
Hi,
Could you set a public variable to True when the DialogBox opens and
False when it closes. Then your Timer macro would not run if the
variable was True.
Don't know about the cell editing problem - perhaps something can be
done with the Worksheet_Change event.

regards
Paul
 
I want make a clarification. The dislog box is not my dialog box...it could
be any excel dialog box also.

I have a workaround for detecting the editing of cell. This is to check if
File->Open is enabled. But i dont think it as a good solution

Any comments......
 
Back
Top