Jim,

"Jim Rech" wrote:

The Document Recovery command bar/task pane should only
appear when you reopen Excel after it crashed with at
least one workbook open. I've never
seen it emerge on its own nor in a grayed out state.

I've seen it (along with users) every so often. I also found some others
having the same problem. As an example
http://groups.google.com/groups?selm...&output=gplain

As I mentioned, I had to use Spy++ to find out the Caption.
Otherwise, previously, I didn't know that it was the Document
Recovery commandbar as it's completely grey, can't be undocked or moved, and
stays the same size (left side of MDI Client in height) upon resizing of
XLMain window.



When it opens after a crash I find
that CommandBars "Document
Recovery").Visible = False makes it disappear, fwiw.

Agreed, I've seen the same. However, it seems that when it appears in the
"grey-mode", it doesn't add itself to the CommandBars collection, so any
attempt to disable it or hide it fails with an error.


Also I wonder if making it appear normally by
doing a forced close of Excel (with a workbook open so
there is something to recover) via C-A-D and a
restart, and then closing the command bar normally,
by clicking its Close
button, will make it start behaving.

I've tried this as well as I have another workbook, which upon closing,
after certain code executes, always crashes. But it doesn't affect the other
Excel instance exhibiting the grey-mode problem.

When this does appear, it overlays everything else, and the user is forced
to save their work and restart Excel. This is pretty annoying to them as this
takes a bit of time on Citrix and the fact the data is stored in SQL Server.

Here's a screenshot of the problem.

http://www.mvps.org/access/images/excel_greybar.jpg

Any other ideas?
Thanks
-- Dev