CODEWITHSUNDEEP
excelvbaadd-inribbon
Hari
Hari

Reputation: 155

Turning Custom Ribbon Tab into Add-In

I am trying to turn a custom ribbon button I made into an add-in that others can use for any worksheet in Excel. I followed this StackExchange post on making a custom ribbon tab to make the ribbon button, and I have it successfully working within one workbook (one Excel Macro Enabled file).

How can I export the ribbon tab XML along with the VBA callback module so another user can use this in their Excel installation?

Thanks!

Upvotes: 1

Views: 1648

Answers (1)

dePatinkin
dePatinkin

Reputation: 2289

There are a few ways to do it. The simplest one is to put your .xlsm file in a known start-up folder like XLSTART.

To find the folders' location, in Excel:

  1. Go to File > Options > Trust Center
  2. Click Trust Center Settings...
  3. Go to Trusted Locations
  4. Put your file in one of the listed XLSTART or STARTUP locations.

The locations look something like this C:\Program Files\Microsoft Office\Root\Office<XX>\XLSTART\ for the whole computer, or like C:\Users\<User>\AppData\Roaming\Microsoft\Excel\XLSTART\ for the user.

When you restart Excel the file should be loaded automatically.

In addition: Saving your file as a .xlam will also make it behave as an add-in, and will not show the worksheet. You can find some information about the file type choice here Excel: Book or Addin.

Upvotes: 2

Related Questions