ExcelBanter - How to avoid delete confirmation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to avoid delete confirmation (https://www.excelbanter.com/excel-discussion-misc-queries/152499-how-avoid-delete-confirmation.html)

Jens Palacios Neffke[_2_]

How to avoid delete confirmation

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

Jim Thomlinson

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

All times are GMT +1. The time now is 02:45 PM.