disable warnings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

larry - 07 Apr 2004 21:17 GMT

I want to be able to delete a worksheet without getting
the built-in warning message every time on Excel 2000 SP2.
Is ther a way to do this? Thanks

Reply to this Message

Dave Peterson - 08 Apr 2004 01:51 GMT

application.displayalerts = false
worksheets("sheet1").delete
application.displayalerts = true

> I want to be able to delete a worksheet without getting
> the built-in warning message every time on Excel 2000 SP2.
> Is ther a way to do this? Thanks

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

Gord Dibben - 09 Apr 2004 00:19 GMT

Larry

Using VBA code.

Sub SheetDelete()
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True
End Sub

If unsure of where to place this code and how to use it, visit David
McRitchie's website for info on getting started with VBA and macros.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP

>I want to be able to delete a worksheet without getting
>the built-in warning message every time on Excel 2000 SP2.
>Is ther a way to do this? Thanks

Reply to this Message