I am trying to delete worksheets in an excel workbook without it prompting me
if i'm sure everytime i do this. Any ideas?

If you are talking about manually, there is no way around it and believe me,
one day you will be happy it does.

If this is part of a macro, use

Application.DisplayAlerts = False

before you delete the sheet and the =True after

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"Lar Chen" <Lar (E-Mail Removed)> wrote in message
news:B7988C3B-1CA3-4CFC-8102-(E-Mail Removed)...
>I am trying to delete worksheets in an excel workbook without it prompting
>me
> if i'm sure everytime i do this. Any ideas?

Lar Chen

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

Only way to get the sheet back is to close without saving, so be careful.


Gord Dibben MS Excel MVP

On Wed, 12 Jul 2006 14:00:02 -0700, Lar Chen <Lar
(E-Mail Removed)> wrote:

>I am trying to delete worksheets in an excel workbook without it prompting me
>if i'm sure everytime i do this. Any ideas?