Removal of standard Delete msg from within VBA

[Darin Kramer]

Hi guys,

My macro creats a new sheet, and also deletes the old sheet. I want to
NOT show the message "Data my exist in the sheet(s) selected for
Deletion. To permanently delete the data press delete", but it shows
when I give the delte command.

Any ideas?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***

[Tom Ogilvy]

Application.DisplayAlerts = False
worksheets(1).Delete
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy


"Darin Kramer" <[email protected]> wrote in message
news:[email protected]...
> Hi guys,
>
> My macro creats a new sheet, and also deletes the old sheet. I want to
> NOT show the message "Data my exist in the sheet(s) selected for
> Deletion. To permanently delete the data press delete", but it shows
> when I give the delte command.
>
> Any ideas?
>
> Thanks
>
> D
>
> *** Sent via Developersdex http://www.developersdex.com ***

[Vobiscum]

hi,

Try with

Sub test()
Application.DisplayAlerts = False
Sheets("sheet1").Delete
Application.DisplayAlerts = True
End Sub


Rgds,

vobiscum


--
Vobiscum
------------------------------------------------------------------------
Vobiscum's Profile: http://www.msusenet.com/member.php?userid=2459
View this thread: http://www.msusenet.com/t-1870567306