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;

Please Login or Register  to view this content.

was changed to...

Please Login or Register  to view this content.

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;

Please Login or Register  to view this content.

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