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.
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.
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.
That will have to wait for Eric then. I am only aware of the “Developer” tab being added in Excel.
Thanks for chiming in, I appreciate it.
Too few OpenXML experts as it is. If I don’t chime in, who will help me?
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.
Great! Thanks for the update.
You must be logged in to reply to this topic.