Delete Sheet
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
Precede with
Application.DisplayAlerts = False and set to True afterwards. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "rajpalmanish" wrote in message news:rajpalmanish.22061y_1137877203.5414@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=503697 |
All times are GMT +1. The time now is 02:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com