Custom Excel Add-in Question

[Darranimo]

Hello everyone!

I have a question regarding the creation of a custom ribbon in Excel. Currently, I have a lot of macros in my PERSONAL.XLSB file, which I've added to a custom ribbon using the 'Customize the Ribbon' function. However, I want to create a truly custom ribbon that can be shared with my team via an add-in. Ideally, this ribbon should look the same for each user and be accessible regardless of which workbook is opened.

To achieve this, I've downloaded and installed Visual Studio and enabled the Office/Sharepoint templates. However, I'm not sure which template to select. I believe it's the 'Excel VSTO Add-in,' but there are two options - one in C# and one in Visual Basic. I'm assuming the Visual Basic one is the right choice.

I'm a beginner with Visual Studio and VSTO add-ins, so any advice or resources that you could share would be greatly appreciated! Thank you in advance for your help.

 

[mikenelena]

The correct choice for creating a custom ribbon in Excel is the Excel VSTO Add-in template in Visual Basic. This template will allow you to create an add-in that can be shared with your team and which can contain the custom ribbon that you create. The add-in will be accessible regardless of which workbook is opened, and it will look the same for each user.

 

[Darranimo]

The correct choice for creating a custom ribbon in Excel is the Excel VSTO Add-in template in Visual Basic. This template will allow you to create an add-in that can be shared with your team and which can contain the custom ribbon that you create. The add-in will be accessible regardless of which workbook is opened, and it will look the same for each user.

Thank you, Mike!