Delete Sheet 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rajpalmanish - 21 Jan 2006 20:58 GMT

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

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

How can I do this?

Thanks and Regards
Manish Rajpa

Reply to this Message

Bob Phillips - 21 Jan 2006 21:36 GMT

U only need to ask once.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> I want to delete a sheet from workbook without any instructions or
> message box. When i try to delete the sheet it ask
[quoted text clipped - 12 lines]
> rajpalmanish's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30623
> View this thread: http://www.excelforum.com/showthread.php?threadid=503698

Reply to this Message

Chip Pearson - 22 Jan 2006 17:32 GMT

Manish,

Use code like

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

"rajpalmanish"

> I want to delete a sheet from workbook without any instructions
> or
[quoted text clipped - 8 lines]
> Thanks and Regards
> Manish Rajpal

Reply to this Message