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 do I save only active worksheet without save all of worksheet

Excel 2003
I have formatted copy of existing worksheet and inserted in to new worksheet
tab.
I do not want the worksheet I edited to change from orginal content.
I am unsure how to save only the active worksheet with out saving the others.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default How do I save only active worksheet without save all of worksheet

Save will save a workbook, not a worksheet.
It sounds as though you need to move your new worksheet into a new workbook
and save that.
If you want a copy of that added as an extra sheet to your original
workbook, close the original book without saving, then reopen and copy from
your new workbook into your old one.
--
David Biddulph

droth wrote:
Excel 2003
I have formatted copy of existing worksheet and inserted in to new
worksheet tab.
I do not want the worksheet I edited to change from orginal content.
I am unsure how to save only the active worksheet with out saving the
others.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default How do I save only active worksheet without save all of worksheet

If that worksheet is going to be used as a template, you may want to just hide
that sheet. Most users won't know where to look or even care.

Select the sheet to hide
Format|sheet|hide

Just unhide it when you need to use it to make another copy.

droth wrote:

Excel 2003
I have formatted copy of existing worksheet and inserted in to new worksheet
tab.
I do not want the worksheet I edited to change from orginal content.
I am unsure how to save only the active worksheet with out saving the others.


--

Dave Peterson
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
When you hit Save on a template, how can you save as worksheet? cwgirl1982 Excel Worksheet Functions 1 September 4th 08 11:18 PM
WORKSHEET SAVE AS Jase Excel Discussion (Misc queries) 0 March 5th 08 08:44 PM
'Save current worksheet'; 'Open next worksheet' - two command buttons englishmustard Excel Discussion (Misc queries) 1 April 7th 06 12:54 PM
save a worksheet Caveman Excel Discussion (Misc queries) 2 December 11th 05 08:28 PM
Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working SuzieQ12345 Excel Worksheet Functions 5 January 21st 05 02:57 PM


All times are GMT +1. The time now is 02:21 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"