I am working on a document in excel, i have 2 buttons on the main 1st sheet. The main button saves the whole document the when i resave the document future weeks it asks which week i want to save which is fine that works. How ever i have created a 2 button but i am wanting this button just to save certain sheets i have got the macro to the button working however when i test the sheet by clicking the button to over save a previous weeks work i get the below message. The file is created as the original document is saved there, so how to i get to to save?