EXCEL: Save Changes Done By Single Module

Dear Experts

There are Multiple Modules available in my File.

I' want to save Changes which are done with particular Module only.

Example:

Public Sub M()
xxxx
xxxx
xxxx
xxxx

SAVE

End Sub

-------------------------

Currently I' am using ThisWorkbook.Save

But this is saving entire changes done in the file - I' Don't want that.

Please Help

Thanks
MG

Thanks for early Reply JOSEPH

I' got your point..

So as a workaround do we have any code which will clear all the unsaved history from the file before I' run the module including the save.

unsaved history should be clear from the last saved action.

this will be a great help.

My Code on Event "Workbook_BeforeClose" only

Actually I' am Hiding Some Sheets while closing.

but if the user do not select SAVE option before close, sheets remain unhidden.

Hence I' am saving the Sheets Hide change force fully - thisworkbook.save

but .. by this users unwanted changes are also getting saved...

so I' am thinking to clear all the unsaved history before hiding sheets and then hide sheets and save.

do you think this will work? and how to use your given code?

Ohhhhh - K

I' never know that.. let me Check.

Checked the same

I' put the hide code in beforesave event

but the sheets are getting hidden with every save...

even i want to save file and want to continue with some other changes

Hey Bro.. there you are

I' have tried the same code.., but file CRASH with particular Scenario

I' have also logged the issue for the same.. check the following link

http://www.excelforum.com/excel-prog...ose-event.html

If file CRASH will resolve.. I' will use that code only, and remove my existing codes