I changed the activewindow.caption and in code in another vba project. Now I have saved the name of the current spreadsheet and activate another spreadsheet. Then when I try to go back to my original spreadsheet, I get the error, "Runtime Error 9 Subscript out of range". But the name of the workbook is exactly the same as the name I am trying to activate. Could the caption change have something to do with my error? Thanks. If so, what do I do?