Save changes to a specific sheet only.

[NewGuy321]

I was wondering if it was possible to only save the changes made to a certain sheet and not save all other changes to the workbook. So if the user moves some objects in sheet 1 and adds some text in sheet 3 the added text in sheet 3 will be saved but the new position of the objects will not. Anyone have any ideas.

 

[philR]

One possible way would be to copy sheet 3 to a different Workbook and save that.

For instance, on the Workbook.BeforeSave event, you could have some code that copies sheet3 to a new workbook and saves it in a certain place, and then cancels the save event. On the Workbook.Open event you could have code which opens the other workbook and copies the contents into sheet3.

If you just have simple text on sheet3, you could alternatively write the contents to a text file whenever sheet3 is deactivated, and read the information in from the same text file each time it is activated. this is surprisingly fast as long as you are not reading in War and Peace!

 

[NewGuy321]

Well thats not what I was really looking for. Customer details are typed in one sheet and the a macro copies and pastes them into a customer database in another sheet. I wanted the customer database to be saved so the newly added customer details are saved. But the changes made elsewhere in the workbook are not.

 

[philR]

Sorry, I don't know of any way to save only one sheet. Could the macro that is copying the information to your database sheet reset all other information before the save?

 

[NewGuy321]

It can't. But thanks anyway for the suggestion.