Hi,

In some Excel 2002 models that I have, after some usage, a grey bar appears
below the formula bar. Restarting Excel is the only way to get rid rid of
it. Right-clicking it gives the All Commandbars context menu.

With the help of Spy++, it seems that the grey bar's caption is "Document
Recovery" and class name "MsoCommandBar". However, it's not listed (or a part
of) the commandbars collection.

I've tried using PostMessage(WM_CLOSE) to try and force it to close, but
am unsuccessful. Has anyone else seen this problem, and if so, is there a
way to close it without restarting Excel?

Thanks
--
Dev

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.

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

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.
--
Jim Rech
Excel MVP
"Dev Ashish" wrote in message
...
| Hi,
|
| In some Excel 2002 models that I have, after some usage, a grey bar
appears
| below the formula bar. Restarting Excel is the only way to get rid rid of
| it. Right-clicking it gives the All Commandbars context menu.
|
| With the help of Spy++, it seems that the grey bar's caption is "Document
| Recovery" and class name "MsoCommandBar". However, it's not listed (or a
part
| of) the commandbars collection.
|
| I've tried using PostMessage(WM_CLOSE) to try and force it to close, but
| am unsuccessful. Has anyone else seen this problem, and if so, is there a
| way to close it without restarting Excel?
|
| Thanks
| --
| Dev

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