How to delete the sheet with out dialogue box

[ramkumar_cpt]

Hi,

I want to delete the sheet with out dialog box. If i click delete sheet option in my excel, One dialogue box (Data may exist in the sheet(s) selected for deletion. To permanently delete the data press Delete.) is opened. I dont want this dialogue box. How to remove this...?

I want delete the sheet immediately with out dialog box after click the delete option.
Pls help me.

Thanks,
Ram.

[Nick Hodge]

Ram

Without code no...if this is a solution for use in code then it is

Application.DisplayAlerts = False

and True before you exit code

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"ramkumar_cpt" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> I want to delete the sheet with out dialog box. If i click
> delete sheet option in my excel, One dialogue box (Data may exist in
> the sheet(s) selected for deletion. To permanently delete the data
> press Delete.) is opened. I dont want this dialogue box. How to
> remove this...?
>
> *I want delete the sheet immediately with out dialog box after
> click the delete option. *
> Pls help me.
>
> Thanks,
> Ram.
>
>
> --
> ramkumar_cpt
> ------------------------------------------------------------------------
> ramkumar_cpt's Profile:
> http://www.excelforum.com/member.php...o&userid=28673
> View this thread: http://www.excelforum.com/showthread...hreadid=490369
>