Since I upgraded to Excel 2007 I can't get macros I record to work in any other workbook other than the one they are created in. I can see from looking in the code that the tab name is part of the macro. I don't know enough about VBA to be able to work around this. I need to be able to run the same macro on many separate yet almost identical files. Each one is a database that shows the same information from file to file. Example, each file is always set up the same way, fields in the same order, the exact same type of information is presented in each one. The only reason they are different files is because they cover different counties, so the account list is different in each one. I need to format these files all the same way but am currently unable to do so without recording a macro for each file. There are too many counties in my state for this to be a viable option. I'm looking to be able to use one macro across the board in all of these different files. Can this be done? Perhaps utilizing a form of wildcard?