Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 5th 06, 07:57 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 5
Default close workbooks without closing excel ?

I save my excel in "my documents" and have several workbooks open at one
time. If i close one excel workbook ....all close and excel closes. If I do
not save every workbook before closing I lose data. How do I set up file just
to close the workbook one at a time ? (Microsoft office excel 2003)

  #2   Report Post  
Old August 5th 06, 09:44 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default close workbooks without closing excel ?

Don't use that X on the application's title bar.

Use the X in the worksheet window's title bar.

Yep, excel behaves differently than MSWord.

Or use File|Close
or ctrl-w (to close the window/workbook)

Clute wrote:

I save my excel in "my documents" and have several workbooks open at one
time. If i close one excel workbook ....all close and excel closes. If I do
not save every workbook before closing I lose data. How do I set up file just
to close the workbook one at a time ? (Microsoft office excel 2003)


--

Dave Peterson
  #3   Report Post  
Old August 5th 06, 09:50 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default close workbooks without closing excel ?


It seems to me that you are not closing a workbook, but exiting Excel.
If this is not the case tou might have an Auto_Close macro that does
this.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=568670



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
Is there a way to force Excel to close workbooks independently? Cam Excel Discussion (Misc queries) 4 February 2nd 06 07:43 PM
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 11 December 4th 05 08:01 PM
Find differences between two Excel workbooks or worksheets savage_planet Excel Discussion (Misc queries) 0 September 19th 05 09:27 PM
Excel Workbooks [email protected] Excel Discussion (Misc queries) 3 September 1st 05 01:28 PM
Closing Excel Diane Excel Discussion (Misc queries) 2 March 24th 05 07:27 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017