ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can I close a worksheet without exiting the wookbook (https://www.excelbanter.com/excel-discussion-misc-queries/159261-how-can-i-close-worksheet-without-exiting-wookbook.html)

Grumpy Ump 1

how can I close a worksheet without exiting the wookbook
 
I need to be able to save and close individual worksheets within a single
Excel workbook. Is there a way of doing this?

JW[_2_]

how can I close a worksheet without exiting the wookbook
 
On Sep 21, 5:58 pm, Grumpy Ump 1 <Grumpy Ump
wrote:
I need to be able to save and close individual worksheets within a single
Excel workbook. Is there a way of doing this?


Worksheets are contained within workbooks. You can not save just a
worksheet unless you want to move each worksheet out of the current
workbook into it's own workbook.


Dave Peterson

how can I close a worksheet without exiting the wookbook
 
Nope.

Worksheets live in workbooks.

Maybe you could hide the worksheets instead???
Select a worksheet to hide
format|sheet|hide


Grumpy Ump 1 wrote:

I need to be able to save and close individual worksheets within a single
Excel workbook. Is there a way of doing this?


--

Dave Peterson


All times are GMT +1. The time now is 02:30 PM.

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