| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete ROW on Sheet#1 corupts data on Sheet#2 | Excel Worksheet Functions | |||
| Delete values in sheet 2 that arre found in sheet 1 | Excel Discussion (Misc queries) | |||
| Delete rows from one sheet containing deatils on the second sheet | New Users to Excel | |||
| How do I un-delete a sheet? | Excel Discussion (Misc queries) | |||
| Delete a sheet | Excel Programming | |||
![rajpalmanish[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
