Excel Personal Macro Workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-131874%22%20slang%3D%22en-US%22%3EExcel%20Personal%20Macro%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131874%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20help.%26nbsp%3B%20Everytime%20I%20record%20a%20macro%20and%20save%20it%20to%20Personal%20Macro%20Workbook%20a%20dialog%20box%20opens%20that%20reads%20%22Personal%20Macro%20Workbook%20in%20the%20startup%20Folder%20must%20stay%20open%20for%20recording%22%20and%20followed%20by%20another%20dialog%20box%20that%20says%20%22Unable%20to%20open%22.%26nbsp%3B%20Then%20the%20macro%20refuse%20to%20record.%26nbsp%3B%20How%20do%20I%20go%20around%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-131874%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20%26amp%3B%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131907%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Personal%20Macro%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131907%22%20slang%3D%22en-US%22%3E%3CP%3EFollow%20this%20path%3A%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EFile%3C%2FSTRONG%3E%26gt%3B%26gt%3B%20%3CSTRONG%3EOptions%3C%2FSTRONG%3E%26gt%3B%26gt%3B%20%3CSTRONG%3EAdd-ins%3C%2FSTRONG%3E%26gt%3B%26gt%3B%20%3CSTRONG%3EManage%3C%2FSTRONG%3EComboBox%20(in%20the%20left%20hand%20corner).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20%3CSTRONG%3EDisabled%20Items%3C%2FSTRONG%3Efrom%20%3CSTRONG%3EManage%3C%2FSTRONG%3EComboBox%2C%20and%20hit%20%3CSTRONG%3EGo...%3C%2FSTRONG%3E%20button.%3C%2FP%3E%0A%3CP%3ECheck%20if%20the%20Personal%20Macro%20Workbook%20is%20disabled%2C%20and%20enable%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20348px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24811iFFF81659FCF914D0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Disabled%20Items.png%22%20title%3D%22Disabled%20Items.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Can anyone help.  Everytime I record a macro and save it to Personal Macro Workbook a dialog box opens that reads "Personal Macro Workbook in the startup Folder must stay open for recording" and followed by another dialog box that says "Unable to open".  Then the macro refuse to record.  How do I go around this problem?

1 Reply
Highlighted

Follow this path:

File >> Options >> Add-ins >> Manage ComboBox (in the left hand corner).

 

Select Disabled Items from Manage ComboBox, and hit Go... button.

Check if the Personal Macro Workbook is disabled, and enable it.

 

Disabled Items.png