Need to turn off dialog boxes

Posted by Bill Ford on March 15, 2001 9:53 AM

I need VBA code to ignore dialog box instead of displaying it. I am running a stock price server that occasionally loses touch with the data feed; pops up an excel warning, but it will not automatically reconnect unless the dialog box is closed. I have no other warnings to worry about, so it does not have to be selective.

Appreciate any help...thnx

Posted by Dave Hawley on March 15, 2001 10:48 AM

Hi Bill

Sounds like you need:

Application.DisplayAlerts=False

You will need to set this back to true when your code is finished.

Dave
OzGrid Business Applications