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.
Thanks for chiming in, I appreciate it.
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.
