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 <[email protected]> wrote in
message news:[email protected]...
>
> ::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]*::
>
>
> --
> dinesh
>
>
> ------------------------------------------------------------------------
> dinesh's Profile:
http://www.excelforum.com/member.php...o&userid=24177
> View this thread: http://www.excelforum.com/showthread...hreadid=377988
>

[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...