Master Command Button to call on other Command Buttons located in other Workbooks

Hello everyone

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.

Nick

If the command buttons are ActiveX-type command buttons, try something like this...

Please Login or Register  to view this content.

The red is the file name of the already opened workbook
The blue is the sheet code name (not the tab name) where the ActiveX command button is located
The orange is the name pf the Command Button procedure.

It wouldn't matter if the command buttons had the same name in different workbooks or worksheets.