Ok I found out part of the problem is that it's saying 'Active Worksheet'. Is there any way to make a loop of the first part of the formatting code and do it on every sheet/tab that the called workbook has? So it will only run once for a 1 tab book and 5 times for a 5 tab book?