Personal Macro Workbook in Startup Folder must stay open for recording

[thewoodington]

Hi Guys,

I am in a panic, I turned on my work computer this mornign to find none of my macros are on there any more. Where have they gone?

I clicked the record button see if it would at least let me install some of my older versions and this came up:

"Personal Macro Workbook in Startup Folder must stay open for recording"

Have I lost all of them? Is there a way to restore them?

Hope you can help.

Kind regards

 

[Trevor G]

By defualt when you start to record a macro it shows you Store Macro in This Workbook when you change this to the Personal Workbook you then would need to use the View Tab to Unhide the Personal Macro Workbook.xlsb.

The workbook can be found in this location.

C:\Users\Your name\AppData\Roaming\Microsoft\Excel\XLSTART\personal.xlsb

If you search for this workbook through your windows explorer it should show it in this location. Then double click to open it, and if you have been storing all your VBA code in the Personal Workbook then it will be in the workbook.

 

[thewoodington]

Thanks Trevor,

I managed to get them all back. It seems Excel had disabled the personal.xls. I went to add-ins in options and clicked to see any disabled items and personal.xls was there. I have now enabled it and it now works.

Why would it change my personal.xls to disabled I have been using the macros in there for months? I did edit one of them yesterday, I guess they made an effect?

 

[VoG]

Excel thinks it is corrupt. See the Problems section http://www.rondebruin.nl/personal.htm

 

[Trevor G]

Pleased to read you have them back,

Perhaps an additional note. From the Personal workbook in the VBA screen Export each Module sheet into a Folder and then if anything else happens to it then you can Import the module sheets back into any workbook.

What I use is something like this. A Named Folder called Module Library

From each workbook that I have VBA in I name each module sheet and add a month year stamp then export them into the Folder, that gives me back up and also a single location to look at if I need to use the code in another workbook.

Names like

modIFStatementsApril2012
modCaseStatementsApril2012
modPublicConstsApril2012

 

[thewoodington]

Thanks for the information.

I will try and do that to keep macros backed up.

What a stress full morning. Thanks guys, have a good day!

 

[jz7jl3]

Excel thinks it is corrupt. See the Problems section http://www.rondebruin.nl/personal.htm

Just FYI: link moved to
How do I create and use a PERSONAL file for my VBA code

 

[lukefrancis]

Trevor G - I can't thank you enough!! My macro's disappeared this morning. I tried recovering them through excel options to no avail and thought they were gone but happily I stumbled across your post and managed to find them. Thanks again buddy!

 

[Trevor G]

Pleased to read you found a solution through searching the forum.

 

[Julica]

This thread helped me today with the March 1, 2017 update for Office 365 / Excel 2016. Thanks!!