Removing some alert messages

[dinesh]

::Guys,


How to remove some of the alert dialog boxes from being displayed.

For example when a web query is refreshed and the address is not found
the excel displays the message \"...............no found\". How
to prevent them from being displayed?


One more thing, The excel displays a message asking \"enable or
disable automatic refresh\" whenever the excel file containing an
automatic web query is opened.
How to remove that dialog box from being displayed?


Please mail me at *[email protected]*::

 

[R.VENKATARAMAN]

did you try this?

application.displayalerts=false

 

[dinesh]

HI VENKATRAMAN




PLEASE TELL ME WHERE TO PUT THAT CODE...

I HAVE GOT ANSWER TO MY SECOND QUERY OF REMOVING THE ENABLE/DISABLE
MACROS DIALOG BOX(I.E., BY SOME REGISTRY SETTINGS).. BUT NOT THE
FIRST ONE... I.E., PAGE NOT FOUND ALERT BOXES...