save entire excel file through VBA

Hello everyone. I need a small solution

I have this code which saves the excel file.

However it only saves changes of sheet 1 and sheet 2.

I have 10 sheets.

I need to save the changes made to all the sheets at once.

The code which i have is

Please Login or Register  to view this content.

Hey Kev,

Thank you .


I have a code which copies cells value from sheet "Invoice" to sheet "Product", "Sales", "Invoice data"

I tried running it but it only saves changes made to sheet "Product" and sheet "Sales".

It does not save changes made to sheet "Invoice data"

Could you please help me?

if you post the full code you are using, then you might get an answer. There is not much to go on, what Kev says if perfectly correct

Hey Davsth,
Thanks for you reply.
I have attached my sample workbook.

In sheet "Invoice" if I press "Update Stock" then it automatically copies data to sheet " Sales" and "Invoice data" and further saves the excel file.

The "update Button" is a command button and it contains series of macros.

So right now the "update stock" copies the data . However it saves data only for sheet " Invoice" , " Product" and "Sales". It does not save the data which is copied in sheet " Invoice data"

So when i close the excel file then it asks me whether I want to save the data.

If I press "yes" then it saves the data which is copied to "invoice data."

If i press "no" then it does not save the data which is copied to "invoice data"

So basically it means that it isnt saving data of sheet "invoice data"

The reason is as Kev says

Please Login or Register  to view this content.

You run the code for save_workbook

before the code for button2_click

so do not save that work, swap them the other way round

Hey Davsth
Hey Kev.


I am really sorry for the trouble. And a big THANK YOU. I dint realize that error. Thank you so much.