Lost macros- How to get them back

[North Wales]

Hi,

Where have all my macros gone.
The computer restarted and now when i open Excel there are no macros, how do
i get them back?

 

[Peter T]

Unless you saved the workbook containing your macros they will be lost. But
maybe you did save it?

Regards,
Peter T

 

[North Wales]

Hi Peter,

It was in the personal macro workbook but now there is nothing.
If i try and record in that folder it says

"Personal Macro Workbook in the startup folder must stay open for recording."

I click ok and get the message unable to record.

Windows Vista keeps using all my proccesing power so i rebooted and thats
when it happened. Some message came up but cant remember what it was.

--
Rich...
http://www.jadwizracing.co.uk

Unless you saved the workbook containing your macros they will be lost. But
maybe you did save it?

Regards,
Peter T

 

[Gord Dibben]

Where were the macros before the computer restarted?

In a workbook that crashed and did not save?

In Personal.xls?

In an add-in?


Gord Dibben MS Excel MVP

 

[Peter T]

I've never seen that message before so I can only speculate that maybe you
were in the process of recording a macro, and closed Excel without pressing
the Stop (recording) button.

Do you have a Personal workbook?
Open the VBE with alt-F11 and look for it in the left panel. If it's there
expand the tree, open and examine any normal modules (for the time being
ignore Sheet and ThisWorkbook modules).

If Personal doesn't exist it was probably never created, or rather never
saved. Normally if Personal has been changed during a session you will get a
prompt when you quit Excel asking if you want to save it.

For future ref, best close all module windows and collapse that tree before
closing Excel and getting the save prompt.

Regards,
Peter T

Hi Peter,

It was in the personal macro workbook but now there is nothing.
If i try and record in that folder it says

"Personal Macro Workbook in the startup folder must stay open for
recording."

I click ok and get the message unable to record.

Windows Vista keeps using all my proccesing power so i rebooted and thats
when it happened. Some message came up but cant remember what it was.

 

[Gord Dibben]

Help>About MS Excel>Disabled Items.

Personal.xls is disabled?

Re-enable and try again.

As noted..........you may have to restart Excel


Gord Dibben MS Excel MVP

 

[North Wales]

Hi,

I think they were in the personal.xls but when i restated Excel the was a
message saying something about add-in but i just clicked quick thinking it
was asking about leting macros run. Does this mean i have lost everything.

 

[North Wales]

Yesssssss you’re a genius,
I clicked the help and Re-enable add-in and there back.

Thanks so much for the help, I was starting to think I was going to have to
spend a lot of time trying to remember how I did everything.

P.S. I have just backed them up, once bitten twice shy.

 

[Gord Dibben]

Good to hear.

I'm not sure what prompts Excel to disable Personal.xls in that manner.

Something to do with the workbook not being trusted but the cause is the
question.

You run macros from Personal.xls for months then all of a sudden Excel
decides it is not trusted so.............usually happens after a crash of
some sort.

Good idea to keep a backup.


Gord