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 8 months, 3 weeks ago.

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #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.

    #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 8 months, 3 weeks ago by  Jim Snyder. Reason: missspellling
    #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.

    #3920

    Jim Snyder
    Participant

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

    #3921

    dclark5
    Participant

    Thanks for chiming in, I appreciate it.

    #3922

    Jim Snyder
    Participant

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

    #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.

    #3925

    Jim Snyder
    Participant

    Great! Thanks for the update.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic.