PDA

View Full Version : Solved: Lost Workbook



FrymanSMU
04-30-2009, 01:21 PM
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
04-30-2009, 01:42 PM
Post the workbook here and let's take a look and see if we can help.

Ken Puls
04-30-2009, 02:44 PM
If the window has just been dragged off screen you may want to try something like the following:
With ActiveWorkbook.Windows(1)
.Top = 1
.Left = 1
.WindowState = xlMaximized
End With

FrymanSMU
05-01-2009, 09:25 AM
I just had our IT team restore the file to the nightly back up version. Thanks for your responses.

Ken Puls
05-01-2009, 10:04 AM
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.