UGH. I am so at my whits end. It saves the file but then it wants to restart and then it closes my current workbook when the main workbook needs to remain open so they can continue to enter their data without closing out. They have 10 or more audits to enter at a time and they do not like the file save as option because it closes the blank so-called template workbook and they want that to remain open and they enter the data and saveas whatever new file name is, they use the claimnumber, membername and date of service and it sets it up as autoclear everything they put in. It worked perfect when I had a button next to my validate button that was save but then the manager of that area said no, they dont want it that way. so i had to recode and now this piece is not working no matter what I do. I am about to just tell the mgr look, I am not an Excel/VBA coder. I know SAS. So, hire someone that knows VBA.