Lost File

P

PeterR

I was working on a file and I accidentally clicked on something ( I
don't know what) and it disappeared. I brought it up again and it
there is nothing there. It still lives where it is supposed to live,
but no file comes up when I open it. Excel opens and that's it.

When I did a search for the file I get a message that says, " please
insert the last disk of the multi-volume set and continue." Huh??

Is this file gone for good, or is it just hiding somewhere?
 
D

DanRoss

Sounds like you might have accidentally hidden the work book.

if you see the file on disk - open it. In 2007 click on the "View" tab -
then find the unhide button. In 2003 I forget. If you cant find it

ALT+F11 (brings up VBA Editor)
CTL+G (displays / hides the imeditate window)

Run this in the imediate window

For each oWindow in Application.Windows: oWindow.visible = True: Next
 
Top