I want to prompt the user to enter a sheet name in an input box and then have the macro search for that sheet name in any open workbook. Once it finds the sheet name I want it to run some minor code to format a pivot table on that sheet. As I know just enough vba to hurt myself....I can't seem to figure out how to search all the open workbooks. The reason for this approach is I want the user of one spreadsheet to be ale to hit a button that runs the macro,formats the pivot and the paste values it into her workbook. The person she gets the data seems to always change the formatting and the file name but the sheet name remains constant. I was thinking by avoiding having to input teh workbook name that it would allow the same code to be used on whichever sheet name was entered and avoid having to enter a workbook and sheet name. Any thoughts or is this just a bad idea?