Recover a lost macro

R

ronben

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Can it be so easy to lose a macro? I intended to create a new macro and clicked 'create' while the name of the first macro in the alphabetic list was displayed. This was not my intent but the code of the original macro with that name appears gone forever. Is it really so easy, if not fatal, to lose a macro by simply forgetting to remove its name from the display before clicking create?

Is any recovery possible?

Please throw a life preserver.
 
J

John McGhie

Hi Ron:

Sorry, it's gone. That's why we make backups.

The VBA code project is part of the template you are using. Roll the
template back to its backup and you'll get the old version back again.

Never do "development" without a meticulous backup regime, because things DO
go "bang" and you will call on the backup quite often...

When you get into the VBA editor, you will find that you can save macros out
as Text Files, and import them back in again. Check the VBA help for
details.

Cheers


Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Can it
be so easy to lose a macro? I intended to create a new macro and clicked
'create' while the name of the first macro in the alphabetic list was
displayed. This was not my intent but the code of the original macro with
that name appears gone forever. Is it really so easy, if not fatal, to lose a
macro by simply forgetting to remove its name from the display before clicking
create?

Is any recovery possible?

Please throw a life preserver.

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top