View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Auto delete of a sheet

Hi Wendell

Use

Application.DisplayAlerts = False
'your code
Application.DisplayAlerts = True



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Wendell A. Clark" wrote in message ...
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.