I hope that someone can help me with this issue i'm having related to command buttons. The problem that I have encountered is that I now have a need to create a master Command Button for a series of other command buttons in a series of separate workbooks because someone else will be providing the maintenance for the report and the series of workbooks are contain sensitive information. I have created a workbook called "Report Control Sheet" where I want to have a master button that when clicked opens and actions the command buttons within 5 different workbooks, I have created everything except the code for calling the CommandButton in each workbook. I have been searching for the right code to use in VBA that would do this however everything I have come across hasn't worked. The other issue is that I haven't renamed the command buttons in each workbook and I don't know if this is causing an issue also?
I'm a bit of a novice when it comes to this stuff as it is all self taught and any help or advice would be really appreciated.