VBA Assistance in Making a button to click all buttons thoughout a workbook

All

For those trying to do this, I was not using Modules but instead putting code under specific buttons on individual worksheets. Excel didn't like this at all. I worked it out eventually though

SOLUTION;

Transfer the code from each button and literally put it straight into a Module. The only difference in code is as follows;

Private Sub CommandButton1_Click()

was changed to...

Sub nameMacro()

Then in the worksheet where I wanted a Master Button to run all workbook macros (having deleted all old buttons in the workbook) I created a new button and called the function from each module as follows having selected the relevant worksheet;

Sub CommandButton1_Click()

Sheets("Name1").Select
Call nameMacro

Sheets("Name2").Select
Call nametwoMacro

End Sub

Works like a treat... so I thought I'd share it since in the past I have gained so much help out of the forum