I think I've found a bug:

You have two Excel 'books' open in one window. One sheet is protected, the
other is not. What I want to do is to paces a reference from one sheet into
another (in order to have the second sheet dynamically update). The bug
comes up if the sheet your are pasting to is locked. When you go to the
window menu to select the second (i.e. locked) sheet, the window changes,
but everything is locked out, and the option to switch back to the original
window is no longer available. Only what to exit is to crash out of
program.

--
Dab

Cut off: yourhead to respond

and the option to switch back to the original window is no longer
available.

It is for me (on the Window menu). Also the convenience shortcut Ctrl-Tab.

--
Jim
"Dab" wrote in message
...
|I think I've found a bug:
|
| You have two Excel 'books' open in one window. One sheet is protected,
the
| other is not. What I want to do is to paces a reference from one sheet
into
| another (in order to have the second sheet dynamically update). The bug
| comes up if the sheet your are pasting to is locked. When you go to the
| window menu to select the second (i.e. locked) sheet, the window changes,
| but everything is locked out, and the option to switch back to the
original
| window is no longer available. Only what to exit is to crash out of
| program.
|
| --
| Dab
|
| Cut off: yourhead to respond
|
|

Yes, I guess I should clarify, I see the original window listed in the menu
as well, and it's not greyed out, but I can't actually select it - noting
happens. I'll try CLT TAB. Thanks.

--
Dab

Cut off: yourhead to respond

"Jim Rech" wrote in message
...
and the option to switch back to the original window is no longer
available.

It is for me (on the Window menu). Also the convenience shortcut
Ctrl-Tab.

--
Jim
"Dab" wrote in message
...
|I think I've found a bug:
|
| You have two Excel 'books' open in one window. One sheet is protected,
the
| other is not. What I want to do is to paces a reference from one sheet
into
| another (in order to have the second sheet dynamically update). The bug
| comes up if the sheet your are pasting to is locked. When you go to the
| window menu to select the second (i.e. locked) sheet, the window
changes,
| but everything is locked out, and the option to switch back to the
original
| window is no longer available. Only what to exit is to crash out of
| program.
|
| --
| Dab
|
| Cut off: yourhead to respond
|
|