Aftersave event - fixed range of cells

Hi all,

How can I return a

Please Login or Register  to view this content.

whenever any cell is changed in columns A or B. I want it to run as an AfterSave event.

I don't think there is an aftersave event, you need to use the beforesave event and code your own save routine then run your code after that.

I would suggest you have a dummy worksheet with a copy of columns A and B and compare this to the actual worksheet to see if they are the same, then after the "aftersave" event is run set the dummy worksheet equal to the actual worksheet.

Hi ragulduy,

That's not quite what I'm after. I require something that shows the MsgBox once the sheet is saved and then (just before) closed. Otherwise it will show everytime a cell is changed within A or B which could be hundreds of times. I essentially only want to show the MsgBox once.

Hi,

I think that is what I described, the program logic would be:
-BeforeSave event triggered
-BeforeSave event calls macro1 and then macro2 and then macro3
-macro1 is your save routine
-macro2 compared the worksheet to the dummy sheet, if it is different it displays message box
-macro3 sets the dummy sheet equal to the worksheet

Ahh yes I see, thank you ragulduy.