Removal of standard Delete msg from within VBA
 

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 ***

Removal of standard Delete msg from within VBA
 

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

--
Regards,
Tom Ogilvy


"Darin Kramer" wrote in message
...
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 ***

Removal of standard Delete msg from within VBA
 

hi,

Try with

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


Rgds,

vobiscu

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