Hi Sixthsense,

Thanks for your reply. As i said i have limited knowledge of VBA, can you please guide me to correct this code as per my requirement.

How can i turning on the events in the codes.

Thanks.