Hi all,
I am trying to figure out if there is a way to detect the presence of the special "Document Recovery" pane which appears at the left when Excel recovers from a crash.
For the normal task pane I can test for Application.CommandBars("Task Pane").Visible = TRUE but I can't seem to find a way of detecting the document recovery one.
Any ideas?
I suppose one way to do this would be to force a crash/recover then run a macro to enumerate all the visible controls/toolbars, but so far I have had no success in actually getting Excel to crash!
The reason I want to be able to detect this is for my current project which always runs from a temporary local copy on the user's C: drive which I don't want resurrected in the event of a crash.
All help/ideas gratefully accepted.
Cheers,
Bruce
Bookmarks