• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 588
  • Last Modified:

Adding a Ribbon to Excel 10 for a custom template

Hello,

I'd like to a ribbon to a to Excel 10 that is attached to either an xltm or xlsm file.  I'm placing the files in xlstart so they are automatically opened with Excel.  When I use the xlsm file the file actually becomes the active workbook (bad) and the ribbon appears (good).  With the xltm file the ribbon does not appear and nor does the document open.

I'd like the ribbon to appear for all workbooks in excel.  I'm using the tool for xml editing that I downloaded here: http://openxmldeveloper.org/archive/2006/05/26/CustomUIeditor.aspx

Thanks.
0
eshurak
Asked:
eshurak
  • 2
  • 2
1 Solution
 
SiddharthRoutCommented:
For that you will have to convert it to an Add-In and then install it so that it will appear in all Excel files. That is what I have done :)

Sid
0
 
eshurakAuthor Commented:
How do I convert it to an "Add-in"?
0
 
SiddharthRoutCommented:
Simply Save the xlsm file as an Addin.

In File Save As, select "Excel -Add-In" as save as type. The Add-In will be saved to the Add-In Folder. You can then install the Add-In as mentioned in this link.

http://www.dq.winsila.com/tips-tricks/ms-office-tips/how-to-install-and-addin-in-excel-2007-and-excel-2010.html

Sid
0
 
eshurakAuthor Commented:
Thanks Sid,

Again I miss the old easier way of just saving a template to xlstart.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now