SOLVED

Saving Name Manager Forumlas

%3CLINGO-SUB%20id%3D%22lingo-sub-1487290%22%20slang%3D%22en-US%22%3ESaving%20Name%20Manager%20Forumlas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487290%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20new%20to%20working%20in%20excel%20in%20a%20professional%20setting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20given%20a%20shared%20document%20and%20I've%20used%20the%20%22Forumulas--%26gt%3BNameManger%22%20functionality%20to%20create%20some%20handy%20forumlas%20to%20count%20color%20ids%20.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%2C%20when%20i%20go%20to%20save%20this%2C%20i%20get%20a%20warning%20about%20macros%20not%20being%20enabled%20and%20i%20need%20to%20change%20the%20file%20type.%20When%20I%20reopen%20this%20file%2C%20all%20my%20macros%20are%20gone.%3CBR%20%2F%3ESince%20I%20have%20zero%20authority%20over%20this%20file%2C%20and%20cant%20very%20well%20demand%20everyone%20switch%20to%20a%20new%20one%20with%20a%20different%20file%20extension%2C%20I%20need%20some%20kind%20of%20work%20around%2C%20so%20I%20can%20reapply%20these%20macros%20to%20the%20shared%20document%20or%20have%20them%20persist%20through%20saves.%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20done%20some%20googling%2C%20about%20macros%20under%20Developer--%26gt%3BRecord%20Macro%20%2C%20but%20that%20seems%20to%20be%20something%20entirely%20different%2C%20and%20this%20naming%20convention%20is%20inhibiting%20my%20ability%20to%20troubleshoot%20my%20exact%20problem.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SteveDatz_0-1593026550517.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200841i77CD06002915341B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22SteveDatz_0-1593026550517.png%22%20alt%3D%22SteveDatz_0-1593026550517.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20advice%20you%20can%20provide.%3CBR%20%2F%3ESteve%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1487290%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1487576%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20Name%20Manager%20Forumlas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F709384%22%20target%3D%22_blank%22%3E%40SteveDatz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20will%20need%20to%20save%20as%20a%20macro%20enabled%20file%20(.XLSM)%20as%20a%20regular%20format%20(.XLSX)%20can%20not%20store%20%2F%20run%20macros.%26nbsp%3B%20In%20the%20Save%20As%20dialogue%20box%2C%20just%20choose%20this%20format%20and%20it%20should%20be%20fine%20on%20reopening.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1488845%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20Name%20Manager%20Forumlas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1488845%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F531239%22%20target%3D%22_blank%22%3E%40Charla74%3C%2FA%3E%26nbsp%3B%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThanks%20for%20the%20reply%2C%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20as%20I%20tried%20mentioning%2C%20I%20dont%20have%20the%20authority%20to%20tell%20people%20to%20all%20stop%20working%20on%20the%20.xlsx%20and%20switch%20to%20my%20xlsm.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20im%20wondering%20if%20there%20is%20any%20work%20around%2C%20like%20if%20I%20can%20save%20those%20macro's%20locally%20on%20my%20machine%20and%20reapply%20them%20everytime%20i%20open%20the%20document%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489085%22%20slang%3D%22en-US%22%3ERe%3A%20Saving%20Name%20Manager%20Forumlas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489085%22%20slang%3D%22en-US%22%3ESure!%20You%20can%20record%20%2F%20save%20%2F%20import%20the%20macros%20in%20your%20Personal!%20(.xlsb)%20file%2C%20which%20means%20they%20are%20available%20in%20the%20Excel%20app%2C%20rather%20than%20in%20a%20specific%20workbook.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fcopy-your-macros-to-a-personal-macro-workbook-aa439b90-f836-4381-97f0-6e4c3f5ee566%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fcopy-your-macros-to-a-personal-macro-workbook-aa439b90-f836-4381-97f0-6e4c3f5ee566%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

I am new to working in excel in a professional setting.

 

I've been given a shared document and I've used the "Forumulas-->NameManger" functionality to create some handy forumlas to count color ids . 

However, when i go to save this, i get a warning about macros not being enabled and i need to change the file type. When I reopen this file, all my macros are gone.
Since I have zero authority over this file, and cant very well demand everyone switch to a new one with a different file extension, I need some kind of work around, so I can reapply these macros to the shared document or have them persist through saves.

I've done some googling, about macros under Developer-->Record Macro , but that seems to be something entirely different, and this naming convention is inhibiting my ability to troubleshoot my exact problem.

SteveDatz_0-1593026550517.png

 

 

Thanks for any advice you can provide.
Steve

3 Replies
Highlighted

@SteveDatz 

 

You will need to save as a macro enabled file (.XLSM) as a regular format (.XLSX) can not store / run macros.  In the Save As dialogue box, just choose this format and it should be fine on reopening.

Highlighted

Hey @Charla74 ,

Thanks for the reply, 

but as I tried mentioning, I dont have the authority to tell people to all stop working on the .xlsx and switch to my xlsm.

 

So im wondering if there is any work around, like if I can save those macro's locally on my machine and reapply them everytime i open the document?

Highlighted
Best Response confirmed by SteveDatz (New Contributor)
Solution
Sure! You can record / save / import the macros in your Personal! (.xlsb) file, which means they are available in the Excel app, rather than in a specific workbook.
https://support.microsoft.com/en-gb/office/copy-your-macros-to-a-personal-macro-workbook-aa439b90-f8...