ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to delete blank worksheets (https://www.excelbanter.com/excel-worksheet-functions/174067-how-delete-blank-worksheets.html)

Keep_It_Simple_Stupid

How to delete blank worksheets
 
My Excel 2007 Workbooks always have a blank Worksheet at the end which I am
unble to delete.

How do I prevent 2007 Workbooks from having this unwanted blank Worksheet
and how do I delete it when it appears?

Use of the Delete Worksheet button to remove blank sheets does not work in
Excel 2007 as it always recreates another blank sheet.

Please, only Excel 2007 solutions. I have tried setting the Office Button
then Excel Options then Include This Many Sheets reset to other values with
no results.

Ron de Bruin

How to delete blank worksheets
 
Hi Keep_It_Simple_Stupid

Very strange

Send me a workbook private and I look at it

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Keep_It_Simple_Stupid" wrote in message
...
My Excel 2007 Workbooks always have a blank Worksheet at the end which I am
unble to delete.

How do I prevent 2007 Workbooks from having this unwanted blank Worksheet
and how do I delete it when it appears?

Use of the Delete Worksheet button to remove blank sheets does not work in
Excel 2007 as it always recreates another blank sheet.

Please, only Excel 2007 solutions. I have tried setting the Office Button
then Excel Options then Include This Many Sheets reset to other values with
no results.




All times are GMT +1. The time now is 06:01 AM.

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