Can not find my personalized macros on Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1420362%22%20slang%3D%22en-US%22%3ECan%20not%20find%20my%20personalized%20macros%20on%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1420362%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3EI've%20a%20question%20about%20my%20lost%20Macros%3A%26nbsp%3B%3CSPAN%3EI%20am%20using%20Excel%20365%20and%20I%20can%20not%20find%20my%20personalized%20macros%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ENot%20sure%20if%20relevant%2C%20but%20this%20happened%20right%20after%20I%20customized%20the%20Quick%20Access%20Toolbar.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EDoes%20anyone%20has%20any%20suggestions%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EMany%20Thanks%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETolga%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1420362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1422668%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20not%20find%20my%20personalized%20macros%20on%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1422668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F680991%22%20target%3D%22_blank%22%3E%40ToTe45%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EWhat%20is%20missing%3F%20the%20icons%20of%20the%20macros%20or%20do%20you%20have%20Userd%20Defined%20Functions%20in%20a%20macro%20workbook%20that%20works%20like%20normal%20Excel%20functions%20like%20when%20written%20in%20a%20cell%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1422885%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20not%20find%20my%20personalized%20macros%20on%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1422885%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F232473%22%20target%3D%22_blank%22%3E%40erol%20sinan%20zorlu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EMany%20thanks%20for%20your%20reply.%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20had%20user%20defined%20functions%20in%20a%20Personalized%20Macro%20Workbook%2C%20but%20I%20can%20not%20find%20that%20Personal%20Workbook%20now.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETolga%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423110%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20not%20find%20my%20personalized%20macros%20on%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423110%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F680991%22%20target%3D%22_blank%22%3E%40ToTe45%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%26nbsp%3B%20File-%26gt%3BOptions%20and%20select%20the%20Add-ins%20option%20from%20the%20left%20menu.%20There%20at%20the%20bottom%20there%20is%20a%20small%20combo%20box%20named%20Manage%2C%20select%20Excel%20Add-ins%20and%20press%20the%20%22Go%22%20botton%20just%20right%20of%20the%20combobox.%20A%20new%20window%20will%20be%20opened%20showing%20all%20the%20add-ins%20by%20a%20special%20workbook%20type%20xlam.%20If%20you%20personalised%20file%20is%20in%20the%20list%20there%20should%20be%20a%20check%20box%20on%20the%20left%20of%20the%20file%20name.%20If%20it%20is%20unchecked%20recheck%20it%20please.%20If%20not%20somehow%20your%20file%20has%20not%20been%20added%20so%20you%20need%20to%20click%20the%20browse%20button%2C%20find%20your%20xlam%20file%20and%20add%20it%20to%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi everyone,

I've a question about my lost Macros: I am using Excel 365 and I can not find my personalized macros

Not sure if relevant, but this happened right after I customized the Quick Access Toolbar.

Does anyone has any suggestions?

Many Thanks

Tolga

3 Replies
Highlighted

@ToTe45 

Hello,

What is missing? the icons of the macros or do you have Userd Defined Functions in a macro workbook that works like normal Excel functions like when written in a cell?

Highlighted

@erol sinan zorlu 

 

Hello,

Many thanks for your reply.

I had user defined functions in a Personalized Macro Workbook, but I can not find that Personal Workbook now.

Regards,

Tolga 

 

@ToTe45 

Please check  File->Options and select the Add-ins option from the left menu. There at the bottom there is a small combo box named Manage, select Excel Add-ins and press the "Go" botton just right of the combobox. A new window will be opened showing all the add-ins by a special workbook type xlam. If you personalised file is in the list there should be a check box on the left of the file name. If it is unchecked recheck it please. If not somehow your file has not been added so you need to click the browse button, find your xlam file and add it to Excel.