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.
|