View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default How to avoid delete confirmation

Applicartion.displayAlerts = False
'Delete your sheet
Application.DisplayAlerts = True
--
HTH...

Jim Thomlinson


"Jens Palacios Neffke" wrote:

Hi.

I got a macro on workbook1 that deletes a sheet on workbook2. But when I
execute it, it shows a warning asking for confirmation. How can I avoid this
warning and getting the sheet deleted?

Any kinda help will be greatly appreciated

Jepane