ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   delete all the spreadsheet (https://www.excelbanter.com/excel-programming/335163-delete-all-spreadsheet.html)

Nader

delete all the spreadsheet
 
Is it possible to delete all the spreadsheet in a workbook ?


Thanks .



Dave Peterson

delete all the spreadsheet
 
You have to have at least one sheet (and it must be visible, too).

But it could be a worksheet, a chartsheet, a dialogsheet, ...

But you have to have at least one.

Nader wrote:

Is it possible to delete all the spreadsheet in a workbook ?

Thanks .


--

Dave Peterson

Bob Phillips[_7_]

delete all the spreadsheet
 
No, Excel insists on at least one remaining.

--
HTH

Bob Phillips

"Nader" wrote in message
...
Is it possible to delete all the spreadsheet in a workbook ?


Thanks .






All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com