Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to detect if user has a dialogbox open
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...... "Paul Robinson" wrote in message om... 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 ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detect open-state of xls from outside Excel | Excel Discussion (Misc queries) | |||
DialogBox | Excel Programming | |||
How to detect Acrobat Distiller open | Excel Programming | |||
How to detect Acrobat Distiller open | Excel Programming | |||
Detect if file is open | Excel Programming |