Forum Discussion

SteveDatz's avatar
SteveDatz
Copper Contributor
Jun 24, 2020
Solved

Saving Name Manager Forumlas

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.

 

 

Thanks for any advice you can provide.
Steve

Excel Desktop
Need Help
  • Charla74's avatar
    Charla74
    Jun 25, 2020
    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-f836-4381-97f0-6e4c3f5ee566

4 Replies

  • Charla74's avatar
    Charla74
    Iron Contributor
    Jun 24, 2020

    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.

    • SteveDatz's avatar
      SteveDatz
      Copper Contributor
      Jun 25, 2020

      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?

      • Charla74's avatar
        Charla74
        Iron Contributor
        Jun 25, 2020
        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-f836-4381-97f0-6e4c3f5ee566

Resources