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!
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!