How to avoid delete confirmation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Applicartion.displayAlerts = False
'Delete your sheet
Application.DisplayAlerts = True
 
Back
Top