I have been enriching high value support in excel programing, its great upto you guys,
I have a another chanllange to answer, hope you solve these one as usal,
I need to make a particulat cell as "Key",
I have worksheet called "WIP", in which cell M12 as key, I have my e-mail id entered in that cell
I need to run code, on worksheet change function of course, if anybody tries to change or delete the e-mail id already entered, entire content of that worksheet should get deleted & worksheet should get saved automatically.
Please note I have certan other macro & "on calculation" event running on same worksheet, so do need to set "Application.EnableEvents = False" prior to that,
ALSO AND IT IS IMPORTANT SO THAT IS WHY I AM USING CAPS On change property also gets triggered, you do nothing but just hit the ENTER button on that cell. So if you were in edit mode in that cell and then clicked ok without even making any change, the ON CHANGE event WILL BE triggered.