Hi Wendell
Use
Application.DisplayAlerts = False
'your code
Application.DisplayAlerts = True
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Wendell A. Clark" <dracowiz@hotmail.com> wrote in message news:%23$THJ6ceGHA.380@TK2MSFTNGP04.phx.gbl...
>I recorded the following code to delete a particular worksheet
>
> Sheets("Temp").Select
> ActiveWindow.SelectedSheets.Delete
>
> My question is how do I suppress the confirmation dialogue?
>
> ANy hel p would be most welcome and thanks ;-)
>
> --
> Wendell A. Clark, BS
> -------------------------------------
>
> CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the
> use of the designated recipients named above. If you are not the intended recipient, please notify us by reply e-mail. You are
> hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or
> copying of it or its contents is prohibited. If you have received this communication in error, please destroy all copies of this
> communication and any attachments. Contact the sender if it continues.
>
>
>
Bookmarks