Custom Ribbon Macros point to old workbook

[missingsc]

I've created a workbook with several coded macros of which I've assigned to buttons in a custom Ribbon tab for the workbook. When I am coding new macros or changing code, I make a copy of the workbook and do it in the new copy so as to not corrupt the current version in case I make a mistake, etc. The problem I run into is that when I do this, all the Ribbon buttons when clicked pull up the old workbook and they get run in the old workbook, not the newly copied one.

From researching, I found that I can resolve the issue by redoing all the buttons in the Ribbon to select the macro name for the new workbook I copied. My question to you all is: can I do something in my macros, workbook, etc. so that I do not have to do this each time and the Ribbon buttons always point to the macros within its workbook, not the previous one I copied from? I would like to distribute this workbook to others but I'm concerned they will get the same problem and/or not be able to see the Ribbon buttons/macros.

Thanks in advance for your help!

 

[Jeffrey Mahoney]

Your custom buttons were created by customizing the ribbon in Excel, right? Unfortunately, the buttons are pointed to that workbook

The best solution for this is to create a custom ribbon for that workbook by editing the UI directly. I do this all the time. I use the Custom UI Editor by Microsoft and a PDF that shows all the icons with names and images to insert into the html. Once you do this once, you'll be a pro and it will be much more professional looking. The new tab, groups, and buttons will only be available when that workbook is active and they get copied with no issues of pointing to the old workbook.

If you want I can give you quick tutorial. It's not difficult to find on the internet, but I could make a copy available on my Google Drive once I get home.

 

[Jeffrey Mahoney]

Look for: OfficeCustomUIEditorFiles.zip
and
Microsoft-Office-2016_365-imageMso-Gallery.pdf

 

[missingsc]

Your custom buttons were created by customizing the ribbon in Excel, right? Unfortunately, the buttons are pointed to that workbook

The best solution for this is to create a custom ribbon for that workbook by editing the UI directly. I do this all the time. I use the Custom UI Editor by Microsoft and a PDF that shows all the icons with names and images to insert into the html. Once you do this once, you'll be a pro and it will be much more professional looking. The new tab, groups, and buttons will only be available when that workbook is active and they get copied with no issues of pointing to the old workbook.

If you want I can give you quick tutorial. It's not difficult to find on the internet, but I could make a copy available on my Google Drive once I get home.

Apologies for the delayed reply...

I must admit I do not understand what you mean in your post. There's really no way of putting the functions, etc. into a specific module or something that always gets referenced correctly when moving the workbook around?

 

[Jeffrey Mahoney]

You can add workbook specific ribbon menus and buttons. These menu tabs and buttons are created inside the workbook and only show themselves when the workbook is open. The buttons refer to the macros inside the VBA project for that workbook. The Custom UI editor from Microsoft allows you to do that. It is very easy to use.