| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Closing a protected workbook
On Feb 7, 5:26*pm, Lerner wrote:
It is normal that when closing a protected workbook and other workbooks not protected are open in the same XL window, they all have to close? Tx ?, How are you closing the workbook? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Closing a protected workbook
With the only options allowable: on the red X on the top right cuadrant.
This is the pictu the workbook does not have the other X probably because is not maXimaSe, however I CAN NOT close it by rightclicking the bottom tab with the workbook name on it even if it 'close' is clickcable down there. Then of course the only option is the red X on the top right that will close all workbooks open. I also know I can open more than one intances of XL but my question really is: Is this a normal behavior or I'm having problems? Thanks CD. "CurlyDave" wrote: On Feb 7, 5:26 pm, Lerner wrote: It is normal that when closing a protected workbook and other workbooks not protected are open in the same XL window, they all have to close? Tx ?, How are you closing the workbook? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Closing a protected workbook
On Feb 8, 5:33*am, Lerner wrote:
With the only options allowable: on the red X on the top right cuadrant. This is the pictu the workbook does not have the other X probably because is not maXimaSe, however I CAN NOT close it by rightclicking the bottom tab with the workbook name on it even if it 'close' is clickcable down there. Then of course the only option is the red X on the top right that will close all workbooks open. I also know I can open more than one intances of XL but my question really is: Is this a normal behavior or I'm having problems? Thanks CD. "CurlyDave" wrote: On Feb 7, 5:26 pm, Lerner wrote: It is normal that when closing a protected workbook and other workbooks not protected are open in the same XL window, they all have to close? Tx ?, How are you closing the workbook? What is maXimaSe? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Closing a protected workbook
You're kidding, not?
On the right top screen you have: minimize, maximize, close.( May be a.. typo!) "CurlyDave" wrote: On Feb 8, 5:33 am, Lerner wrote: With the only options allowable: on the red X on the top right cuadrant. This is the pictu the workbook does not have the other X probably because is not maXimaSe, however I CAN NOT close it by rightclicking the bottom tab with the workbook name on it even if it 'close' is clickcable down there. Then of course the only option is the red X on the top right that will close all workbooks open. I also know I can open more than one intances of XL but my question really is: Is this a normal behavior or I'm having problems? Thanks CD. "CurlyDave" wrote: On Feb 7, 5:26 pm, Lerner wrote: It is normal that when closing a protected workbook and other workbooks not protected are open in the same XL window, they all have to close? Tx ?, How are you closing the workbook? What is maXimaSe? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Closing a protected workbook
The protected workbook does not have any "x" because you checkmarked
"Windows" when you protected it. If you clear that checkbox and just check "Structure" you will get normal access to the min/max, restore and "x" But FileClose will close only the active workbook in any case. Gord Dibben MS Excel MVP On Sun, 8 Feb 2009 04:33:01 -0800, Lerner wrote: With the only options allowable: on the red X on the top right cuadrant. This is the pictu the workbook does not have the other X probably because is not maXimaSe, however I CAN NOT close it by rightclicking the bottom tab with the workbook name on it even if it 'close' is clickcable down there. Then of course the only option is the red X on the top right that will close all workbooks open. I also know I can open more than one intances of XL but my question really is: Is this a normal behavior or I'm having problems? Thanks CD. "CurlyDave" wrote: On Feb 7, 5:26 pm, Lerner wrote: It is normal that when closing a protected workbook and other workbooks not protected are open in the same XL window, they all have to close? Tx ?, How are you closing the workbook? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Closing a protected workbook
Yes Sir!
Tx Gord. "Gord Dibben" wrote: The protected workbook does not have any "x" because you checkmarked "Windows" when you protected it. If you clear that checkbox and just check "Structure" you will get normal access to the min/max, restore and "x" But FileClose will close only the active workbook in any case. Gord Dibben MS Excel MVP On Sun, 8 Feb 2009 04:33:01 -0800, Lerner wrote: With the only options allowable: on the red X on the top right cuadrant. This is the pictu the workbook does not have the other X probably because is not maXimaSe, however I CAN NOT close it by rightclicking the bottom tab with the workbook name on it even if it 'close' is clickcable down there. Then of course the only option is the red X on the top right that will close all workbooks open. I also know I can open more than one intances of XL but my question really is: Is this a normal behavior or I'm having problems? Thanks CD. "CurlyDave" wrote: On Feb 7, 5:26 pm, Lerner wrote: It is normal that when closing a protected workbook and other workbooks not protected are open in the same XL window, they all have to close? Tx ?, How are you closing the workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Closing only one excel workbook | Excel Discussion (Misc queries) | |||
| Closing a workbook upon opening another | New Users to Excel | |||
| STOP WORKBOOK CLOSING | Excel Discussion (Misc queries) | |||
| Help with closing down a workbook?? | Excel Worksheet Functions | |||
| prohibit closing a workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
