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
|