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