Delete Sheet 1
 

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

--
rajpalmanis
-----------------------------------------------------------------------
rajpalmanish's Profile: http://www.excelforum.com/member.php...fo&userid=3062
View this thread: http://www.excelforum.com/showthread.php?threadid=50369

Delete Sheet 1
 

U only need to ask once.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"rajpalmanish"
wrote in message
news:rajpalmanish.22061z_1137877203.9354@excelforu m-nospam.com...

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

Delete Sheet 1
 

Manish,

Use code like

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




"rajpalmanish"
wrote
in message
news:rajpalmanish.22061z_1137877203.9354@excelforu m-nospam.com...

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