If the macro needs to be available for any workbook they have open then you have two main choices. You can either get them to put it in their personal.xls or you can distribute it as an add-in. The add-in would be the better choice here but it would also come with a fairly significant learning curve.

I highly appreciate your great support. I spent hours trying to complete the add-in issue but without success and I need your help.

My Macro3 is located in Microsoft Excel Macro-Enabled Worksheet (New3.xlsm). I have re-saved this file as “Excel Add-in” and not as "Excel 97-2003 Add-in".

By default, the file was saved under D:\Users\myaccount\AppData\Roaming\Microsoft\AddIn s.

Then, in this new Microsoft Excel Add-In (New3.xlam) file, I have customized the Ribbon tool bar and created a new group under data and linked this new group with the Macro3 which I found it in the Macro list (in the left side).

Now, when I opened the original New3.xlsm file (Macro-Enabled Worksheet), I found Macro3 sign appear in the new data group that I have created in the Add-in file.

The Macro3 sign in the New3.xlsm work fine even after I removed the Macro3 from it.

The problem is when I sent this file to 3 of our users (as a test) and the Macro setting was enabled on their BCs; it did not work where they could not see the macro sign.