View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Does an open dialog box slow down or stop a Macro?

Doug

the dialogue box will stop the macro until the user responds to it.

Regards

Trevor


"Doug" wrote in message
...
A macro I am working on looks at two columns of cells. The cells are

updated dynamically from another process. If a cell (A1) is more than twice
the adjacent cell (B1) (only concerned with one row at a time), a dialog box
appears with a warning. The user has two click OK to close the dialog box.
If the user is away from his desk, will that open dialog box slow down or
stop the dynamic update or the macro itself from running (from checking
other cells for the same condition)? Thanks.
Doug