This maybe a simple/ridiculous question, but I am trying to make changes to the ribbon in excel (removing all other tabs and just having my own with macros etc). This is to be used as a basic data entry workbook for other users...

My only issue is that when the changes are made it applies it to every other workbook that I open in excel, I was thinking that there should just a setting that you could change to apply the changes. But looking online I am thinking that I need some VBA, that changes the ribbon on opening and closing of the spreadsheet?

Can anyone confirm/deny this? point me in the right direction?

CodePudding user response：

You can embed your ribbon customizations along with VBA macros into a macro-enabled workbook, so your customizations will be available only to the particular file. The samples that shows how to hide or display ribbon tab/group with getVisible callbacks are available for download.

CodePudding user response：

Take a look at this: https://github.com/fernandreu/office-ribbonx-editor

This is exactly what you need.