Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to force Excel to close workbooks independently?
When opening and working in multiple workbooks in Excel 2002, each workbook
opens in a separate window. However, when you click on the X in the top right corner of one workbook, Excel attempts to close all the open workbooks at once. Is there a way to stop this? Word does not work this way and I cannot find any reference in the help files on a way to turn this feature off. Does it require a registry edit? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to force Excel to close workbooks independently?
Word and excel work differently.
In excel, you don't want to use that application X to close any single window. It closes the application. But you can just use the sheet's window's X to close that window. Cam wrote: When opening and working in multiple workbooks in Excel 2002, each workbook opens in a separate window. However, when you click on the X in the top right corner of one workbook, Excel attempts to close all the open workbooks at once. Is there a way to stop this? Word does not work this way and I cannot find any reference in the help files on a way to turn this feature off. Does it require a registry edit? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to force Excel to close workbooks independently?
Hi Cam,
When I have more than one workbook open and if each open workbook has only one window, then clicking the little black cross (below the larger black cross with red background) closes only the active workbook. If an open workbook has more than one window then clicking that little black cross only closes the active window. This is on Excel 2003, Windows XP. Ken Johnson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to force Excel to close workbooks independently?
The reason this is an issue is that Excel is the only application I use that
functions this way. All other applications close each window independently and I don't want to have to remember to use a different method of closing a window just for Excel. "Cam" wrote: When opening and working in multiple workbooks in Excel 2002, each workbook opens in a separate window. However, when you click on the X in the top right corner of one workbook, Excel attempts to close all the open workbooks at once. Is there a way to stop this? Word does not work this way and I cannot find any reference in the help files on a way to turn this feature off. Does it require a registry edit? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to force Excel to close workbooks independently?
Don't use the X associated with the application window.
use the X associated with the sheet window. (Yes, excel works differently than MSWord.) Cam wrote: The reason this is an issue is that Excel is the only application I use that functions this way. All other applications close each window independently and I don't want to have to remember to use a different method of closing a window just for Excel. "Cam" wrote: When opening and working in multiple workbooks in Excel 2002, each workbook opens in a separate window. However, when you click on the X in the top right corner of one workbook, Excel attempts to close all the open workbooks at once. Is there a way to stop this? Word does not work this way and I cannot find any reference in the help files on a way to turn this feature off. Does it require a registry edit? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Why does Excel close all workbooks? | Setting up and Configuration of Excel | |||
To stop Excel from opening many workbooks at startup | Excel Discussion (Misc queries) | |||
Excel does not display workbooks open | Setting up and Configuration of Excel | |||
Excel 2003 crashes when I close any worksheet | Excel Discussion (Misc queries) |