I was messing around in Excel and accidentally deleted all of my macros
I think. I used:

Application.DisplayAlerts=False
ThisWorkbook.ChangeFileAccess xlReadOnly
Kill ThisWorkbook.FullName
ThisWorkbook.Close False

Is there anyway I can get them back?


--
Losse
------------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...o&userid=24813
View this thread: http://www.excelforum.com/showthread...hreadid=386932

Good evening Losse

Unfortunately it won't be simple, unless you had a back-up. As you
have discovered, the kill command is a bit more brutal than pressing
delete from Windows - which sends a file to the recycle bin.

However, all is not lost, because you have deleted the file, not
removed the macro and saved the macro-free file back over itself. You
may be able to recover the file using an undelete utility. Try
searching Google for just that.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=386932

I see only expensive programs for undeleting corrupted macros. Were mine
simply corrupted or were they deleted?


--
Losse
------------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...o&userid=24813
View this thread: http://www.excelforum.com/showthread...hreadid=386932

Hi Losse

Your macros are saved as part of the file. The file has been deleted,
therefore the contents of the file and your macros have gone. If you
can undelete the file - and programs are available that will do this -
your data and macros can be recovered intact.

http://www.google.co.uk/search?hl=en... are%22&meta=

this link is a Google page searching for freeware undelete utilities.
I haven't used an undelete facility since Nuts'n'Bolts was available,
so can't recommend one. You could try asking here for a good freeware
utility (unless someone reading this forum can recommend one...?):

http://www.computerforum.com/forumdisplay.php?f=17

Good luck

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=386932

I belive I killed "Book1." How am I supposed to find this? It was never
saved, and that is the default name to Excel worksheets.


--
Losse
------------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...o&userid=24813
View this thread: http://www.excelforum.com/showthread...hreadid=386932

If it was never saved, then you couldn't have "killed" it (kill deletes a file
on disk).

But since that code closed the workbook, too, it's gone and so are the macros in
it.




Losse wrote:

I belive I killed "Book1." How am I supposed to find this? It was never
saved, and that is the default name to Excel worksheets.

--
Losse
------------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...o&userid=24813
View this thread: http://www.excelforum.com/showthread...hreadid=386932

--

Dave Peterson

My macros were all saved to the PERSONAL.XLS anyways...


--
Losse
------------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...o&userid=24813
View this thread: http://www.excelforum.com/showthread...hreadid=386932