Lost personal macro workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1051447%22%20slang%3D%22en-US%22%3ELost%20personal%20macro%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1051447%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20recently%20got%20a%20new%20App%20MacBook%20and%2C%20I%20transferred%20all%20the%20information%20over%20the%20wifi%20transfer%20feature.%20I%20then%20went%20to%20excel%20to%20record%20a%20macro%20and%20received%20this%20message%20%22Personal%20Macro%20Workbook%20in%20the%20startup%20folder%20must%20stay%20open%20for%20recording.%22%20The%20workbook%20is%20not%20disabled%20in%20the%20add%20ins%20tab%2C%20it%20does%20not%20even%20appear%20as%20an%20option.%20I%20went%20to%20VBA%20to%20find%20the%20Startup%20path%2C%20and%20it%20says%20it%20exists%20but%20I%20cannot%20find%20it%20anywhere%20on%20my%20computer.%20How%20do%20I%20recover%20it%2C%20or%20go%20about%20creating%20a%20new%20one%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1051447%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055827%22%20slang%3D%22en-US%22%3ERe%3A%20Lost%20personal%20macro%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055827%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F479301%22%20target%3D%22_blank%22%3E%40eland012%3C%2FA%3E%26nbsp%3BI%20think%20you%20can%20create%20a%20new%20one%20just%20by%20recording%20a%20simple%20macro%20and%20telling%20it%20to%20save%20in%20your%20Personal%20Macro%20workbook.%20This%20should%20generate%20one%20if%20one%20does%20not%20already%20exist.%20Once%20it%20is%20created%2C%20you%20can%20click%20%22Unhide%22%20in%20the%20View%20Tab%20on%20the%20ribbon%20to%20unhide%20the%20workbook%2C%20then%20click%20File%20Menu%20to%20see%20the%20exact%20location%20of%20where%20it%20is%20saved.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

So I recently got a new App MacBook and, I transferred all the information over the wifi transfer feature. I then went to excel to record a macro and received this message "Personal Macro Workbook in the startup folder must stay open for recording." The workbook is not disabled in the add ins tab, it does not even appear as an option. I went to VBA to find the Startup path, and it says it exists but I cannot find it anywhere on my computer. How do I recover it, or go about creating a new one?

2 Replies

@eland012 I think you can create a new one just by recording a simple macro and telling it to save in your Personal Macro workbook. This should generate one if one does not already exist. Once it is created, you can click "Unhide" in the View Tab on the ribbon to unhide the workbook, then click File Menu to see the exact location of where it is saved.

@CWagner  I am having the same issue as above.  When I try to record a new macro I get the message 'Personal Macro Workbook in the startup folder must stay open for recording'.  I have located my XLSTART folder on my C drive and can see my saved macros there.  For some reason it seems that XLSTART is not opening or has become unattached to my Excel program.  I don't know how to get it back running automatically.