Open XML Package Editor to Create a Ribbon Button that runs a VBA Function

Home › Forums › SpreadsheetML › Open XML Package Editor to Create a Ribbon Button that runs a VBA Function

Tagged: ,

This topic contains 7 replies, has 2 voices, and was last updated by  Jim Snyder 7 years, 5 months ago.

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • October 28, 2016 at 9:09 pm #3914

    dclark5
    Participant

    I know this is awhile ago however I have just been given a job by a client to update a xla project I wrote way back when to Office 2010. There are considerable amounts of functions that this tool would help me to convert in the new ribbon format. I have migrated the project to Excel 2010.

    I downloaded the tool, installed it in Visual Basic 2010, followed your instructions however the new tab/group doesn’t show up. I carefully checked my entries and couldn’t find any problems.

    Would appreciate any help on this.

    October 31, 2016 at 12:43 pm #3917

    Jim Snyder
    Participant

    Are you referring to the “Developer” tab in Excel? If so, it is a setting you have to change. Under the “File” menu open the “Options”. Open the “Customize Ribbon” window and select the “Developer” checkbox.

    • This reply was modified 7 years, 5 months ago by  Jim Snyder. Reason: missspellling
    October 31, 2016 at 12:56 pm #3919

    dclark5
    Participant

    I am aware of that but that’s not what I was referring to. I am referring to editing the xlsm file using a Open XML Package Editor tool referred to in Eric’s YouTube video. It installs with Visual Studio so you can edit (add to) the ribbon through code. There is a laborious way to do it manually but using this add in you can load the file in VS and using HTML modify the ribbon easily.
    I loaded the tool, edited the file in VS but after saving it there is no change in the Excel file ribbon.
    I do see how you can use the Developer tab to add a tab/group/buttons and assign macros, which I have done. However it would be better for me if this VS method worked.

    October 31, 2016 at 1:41 pm #3920

    Jim Snyder
    Participant

    That will have to wait for Eric then. I am only aware of the “Developer” tab being added in Excel.

    October 31, 2016 at 4:19 pm #3921

    dclark5
    Participant

    Thanks for chiming in, I appreciate it.

    October 31, 2016 at 4:45 pm #3922

    Jim Snyder
    Participant

    Too few OpenXML experts as it is. If I don’t chime in, who will help me?

    November 1, 2016 at 11:24 pm #3924

    dclark5
    Participant

    UPDATE****
    The editor did work. The problem is the workbook I created the tab for is code and user forms only. When it opens work files the tab is not there. And of course in the VBA editor you wouldn’t see it but when you switch to the forms worksheet there it is!

    So now the big question is how do you get the custom tab to display with all workbooks and not just the one modified with this code. Hope this makes sense to someone.

    November 2, 2016 at 12:41 pm #3925

    Jim Snyder
    Participant

    Great! Thanks for the update.

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic.