View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Robinson Paul Robinson is offline
external usenet poster
 
Posts: 208
Default how to detect if user has a dialogbox open

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


"Von Shean" wrote in message ...
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 ??