Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,123
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete Blank Rows Heather Excel Discussion (Misc queries) 9 July 15th 08 09:32 PM
Delete Blank Rows Code - Multiple Worksheets - Multiple Documents BenS Excel Discussion (Misc queries) 3 June 29th 07 12:20 AM
where can I down Blank Worksheets, blank stmt. of account forms carmen Excel Discussion (Misc queries) 2 January 15th 07 03:03 PM
Is there a easy way to delete blank lines to clean up worksheets? jdf5 Excel Worksheet Functions 2 June 4th 06 06:05 PM
"BLANK" - need to delete anjgoss Excel Worksheet Functions 3 August 25th 05 05:31 PM


All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"