Excel Add-in is not appearing in Data Ribbon

[pradee]

Hi,

I am creating a new excel Addin and i have added some macro to it,
when i am trying to add it to the excel with Normal procedure it is not appearing in the data Ribbon of the excel,
and i have added the Addin location to the Trusted location option,
please kindly help with this, i am not getting where i ma going wrong.
Normal procedure:
1. Go to File--> Options
2. Click Add-ins tab
3. Manage--> Excel Addins and Go
4. Brows for Add-in and select and click ok.

This is the procedure i followed to add addin to the excel.

the add-in getting added to the excel successfully, i can add forms and models, but the button not showing in Data Ribbon.

please provide me a solution, am tring it ny two days but not happenning

 

[RoryA]

How did you create the button?

 

[pradee]

@RoryA i have not created button, i have created addin Filename.xlam

 

[RoryA]

If you haven't created one, why would you expect one to appear in the Ribbon?

 

[pradee]

@RoryA, i think you have not understood my question, i am creating an Excel Add-in Tool, which i want to access it from Data Ribbon, Normal procedure i have mentioned in the question, but with that it is not showing in the Data Ribbon.

Appologies if i am not able to clarify

 

[RoryA]

What exactly does "Normal procedure" mean to you? If you mean manually customising the Ribbon through the Excel interface, that will not work. You need to edit the XML of the file - see Ron's pages here: http://www.rondebruin.nl/win/section2.htm

 

[pradee]

Normal procedure means, to add Excel Add-in tool To the ecxcel, and i am not creating any button or Ribbon, i just want to add Excel Add-in to the excel,
Am i Clear?

 

[pradee]

What exactly does "Normal procedure" mean to you? If you mean manually customising the Ribbon through the Excel interface, that will not work. You need to edit the XML of the file - see Ron's pages here: http://www.rondebruin.nl/win/section2.htm

Can you go through the steps that i have mentioned in the question. I hope you get clarity

 

[RoryA]

Not really. It's all covered in Ron's pages and I'm afraid I'm not going to retype it all.