VBA Forced Sheet2 Deletion without having to Answer Popup

[rmfrase]

Is there a way to Force Delete a worksheet in VBA, but yet not have to respond to the quesiton of:

"Data May Exist in the sheet(s) selected for Deletion. To perminately Delete the Data, Press Delete."




Thanks.
Robert

 

[Lewiy]

Application.DisplayAlerts = False

 

[dave3009]

Aye

Just pop

Application.DisplayAlerts = False

Before that event

Then

Application.DisplayAlerts = True

After the event

HTH


Dave

 

[rmfrase]

Thank you both so very much - I never knew. I'd like to find a complete listing sometime of all of the Excel VBA Commands.

That way I wouldn't have to keep asking all of these questions...

-Robert

 

[dave3009]

Never be afraid to ask, debate on an issue can provide a range of excellent answers to provide a superb educational resource to those searching for answers