Hi Leith,

I was able to save the macro.
In the code provided by RoyUK, i have placed my email address. Then what should I do? i tried to update that excel sheet and then save again, but i did not receive an email.
just want to make sure if i am not doing something which needs to be done or vice-versa?
By the way thanks for helping me out in saving the macro