Apply macro to all workbooks in folder

Hi everyone,

I have the following codes:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I run them both via:

Please Login or Register  to view this content.

However, i was wondering if there was a way I could apply this to all of the workbooks in a particular folder? Simply to save having to do this to a large number of spreadsheets.

There are 61 spreadsheets in a folder called "GR12 Schedules" and each file is called "GR12 Schedule" and then a number i.e Schedule 1, Schedule 2 etc up to 61

Many thanks,

Chris

Hi AlphaFrog,

Many thanks for your response, much appreciated

I have amended your code to fit with the correct folder locations etc and I am getting "0 files coloured" messaged at the end.

Please Login or Register  to view this content.