Emergency !!!

[matthew230]

Hi,

I have spent the whole day coding a little utility to automate some document production.

Unfortunately during testing I have managed to lock it into some kind of loop. I have a macro instructing it to print a sheet from a userform button. It has now opened the print preview screen, but I forgot to hide the userform, and now everything is jut binging at me when I click on it.

I checked when I had last saved it, and it was 2 hours ago !!

Anybody know any tricks to get out of this l

Thanks,

Matt

 

[dave3009]

there must be some other problem than your code, do you not use Autorecover in which case closing Excel will only lose the amount of data from the last auto save

 

[matthew230]

Solved !!

Ok, I managed to recover the data:

If anyone else is as stupid as me.. just read the below link, find the relevant file and drag it into a new open workbook

http://support.microsoft.com/kb/289273/