Solved: Lost Workbook

[FrymanSMU]

Ok I don't know what happened. I don't even know how to Hide objects in VBA but somehow my entire workbook disappeared. I have a button from another workbook I was trying to copy over, I accidently launched the code and it did something crazy. Now my excel window has nothing but the main toolbar and nothing else.

Does anyone have a script to restore the window? Set.Normal or Window.show I tried a bunch of things but I'm not very familar with Excel coding. Any help is appreciated, thanks in advance.

Rich

[Bob Phillips]

Post the workbook here and let's take a look and see if we can help.

[Ken Puls]

If the window has just been dragged off screen you may want to try something like the following:
[vba] With ActiveWorkbook.Windows(1)
.Top = 1
.Left = 1
.WindowState = xlMaximized
End With[/vba]

[FrymanSMU]

I just had our IT team restore the file to the nightly back up version. Thanks for your responses.

[Ken Puls]

Tell your IT team to implement shadowcopy on your servers so you can do it yourself next time. Trust me, it's saved me a TON of time restoring from tape since I turned that feature on.