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

[Jim SnyderParticipant]

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 years, 7 months ago by  Jim Snyder. Reason: missspellling

[dclark5Participant]

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.

[Jim SnyderParticipant]

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

[dclark5Participant]

Thanks for chiming in, I appreciate it.

[Jim SnyderParticipant]

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

[dclark5Participant]

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.

[Jim SnyderParticipant]

Great! Thanks for the update.

[Author]

Posts