Use Personal Workbook or Add-Ins to Store Code to Be Used Globally?

Results 1 to 4 of 4

Thread: Use Personal Workbook or Add-Ins to Store Code to Be Used Globally?

  1. #1
    Board Regular
    Join Date
    Feb 2008
    Posts
    78
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Use Personal Workbook or Add-Ins to Store Code to Be Used Globally?

     
    Using Excel 2013 & 2016.

    I just created an .xlam add-in for the first time today. A UDF user defined function was added to a blank workbook and saved as .xlam file in the Microsoft Add-Ins folder.

    If you have many macros that you use globally, that is you use for/on any workbook, is it better to store many modules in the Personal workbook or create many add-in workbooks?

    Thank you.

  2. #2
    Board Regular
    Join Date
    Apr 2012
    Location
    Texas, USA
    Posts
    515
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Use Personal Workbook or Add-Ins to Store Code to Be Used Globally?

    It would be the same either way. Both workbooks would open when Excel opens and both have the option of have custom tabs/quick access toolbar. I typically only do an add-in when I have a set of tools that I will give to other users. If I'm using them myself, I just keep them in the personal.xlsb. If I use the macro often, I'll add it to my quick access toolbar, but it's just as easy to add a custom tab and link the macros that way, as well.

  3. #3
    Board Regular
    Join Date
    Feb 2008
    Posts
    78
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Use Personal Workbook or Add-Ins to Store Code to Be Used Globally?

    Thank you! God bless you!

  4. #4
    Board Regular
    Join Date
    Apr 2012
    Location
    Texas, USA
    Posts
    515
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Use Personal Workbook or Add-Ins to Store Code to Be Used Globally?

      
    You're welcome!

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com