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
Bob Phillips - 21 Jan 2006 21:36 GMT
Precede with
Application.DisplayAlerts = False
and set to True afterwards.
--
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=503697