Running 3 different macros across selected multiple worksheets in one workbook

Hi,
Hopefully someone will find this easy to solve because it has been very difficult for me.

I have a spreadsheet with 3 macros that are designed to run on specific worksheets as follows:
Calibrate - should only run on worksheets beginning from SN to GD (28 worksheets)
CogCalibrate - should only run on 2 worksheets (WP & NS)
BIGCalibrate - should only run on 1 worksheet (BIG)

None of these macros should run on the remaining 5 worksheets (Contents, Instructions, DescriptiveStats, CalibrationSummary, Data).

To make it easier for other people to use this spreadsheet I have created a Contents page. How can I modify these macros to allow them to be run from buttons on the CONTENTS page? I have looked and tried various examples without success.

Excellent. Thanks very much. RunBigCalibrate and RunCogcalibrate work perfectly. Unfortunately the worksheet names for the third macro are of varying lengths. I am writing the macro now and will get back to you once I have finished and tested them. Is there an option to maybe tell this macro to omit sheets instead of telling it to find specified sheets?

To 'omit' like you wanted, probably like this:

Please Login or Register  to view this content.

Fantastic. Works perfectly. One final thing. I wanted to add a message to confirm the macro has run successfully and have modified your macro as below. It seems to work when tested it but I wanted to make sure that this is the right way of doing it.

Please Login or Register  to view this content.

If I assumed correctly that txt_err is a global variable used by your other macros to store the 'processing failed' sheets, then yes it should be working fine.

You might need to set it to "" first though (if you haven't).

Please Login or Register  to view this content.

Thanks for all your help with this. very quick and efficient.