There is a way to run code with all workbooks. I can modify the code I sent you to do this however it is important that when running code on multiple workbooks that they each have similar attributes.

Do all of the workbooks have multiple sheets that need this ran or just the first sheet?
Are all of the workbooks a certain type of name so the code can skip over workbooks that dont meet that criteria?
Are all of the workbooks in one folder? I can research how to get Excel to open and process each file from a folder but the first 2 questions would need to be answered before we do that.

I can write something that will run in all OPEN workbooks pretty easily but you will probably not want to open up 50+ workbooks on your computer.

Thanks