Delete Sheet 1

[rajpalmanish]

I want to delete a sheet from workbook without any instructions or message box. When i try to delete the sheet it ask

"Data may exist in the sheet(s) seletion for deletion. To permanentely delete the data, press delete."

How can I do this?

Thanks and Regards
Manish Rajpal

[Bob Phillips]

U only need to ask once.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"rajpalmanish" <[email protected]>
wrote in message
news:[email protected]...
>
> I want to delete a sheet from workbook without any instructions or
> message box. When i try to delete the sheet it ask
>
> "Data may exist in the sheet(s) seletion for deletion. To permanentely
> delete the data, press delete."
>
> How can I do this?
>
> Thanks and Regards
> Manish Rajpal
>
>
> --
> rajpalmanish
> ------------------------------------------------------------------------
> rajpalmanish's Profile:
http://www.excelforum.com/member.php...o&userid=30623
> View this thread: http://www.excelforum.com/showthread...hreadid=503698
>

[Chip Pearson]

Manish,

Use code like

Application.DisplayAlerts = False
' delete the sheet
Application.DisplayAlerts = True




"rajpalmanish"
<[email protected]> wrote
in message
news:[email protected]...
>
> I want to delete a sheet from workbook without any instructions
> or
> message box. When i try to delete the sheet it ask
>
> "Data may exist in the sheet(s) seletion for deletion. To
> permanentely
> delete the data, press delete."
>
> How can I do this?
>
> Thanks and Regards
> Manish Rajpal
>
>
> --
> rajpalmanish
> ------------------------------------------------------------------------
> rajpalmanish's Profile:
> http://www.excelforum.com/member.php...o&userid=30623
> View this thread:
> http://www.excelforum.com/showthread...hreadid=503698
>