View Single Post
 
Old 04-30-2012, 03:01 AM
ibrahimaa ibrahimaa is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: May 2011
Posts: 35
ibrahimaa is on a distinguished road
Default

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.
Reply With Quote