With the help from the gurus in this site,(The details of my request are in https://www.experts-exchange.com/questions/29093251/Sheet-falls-in-to-calculation-mode-when-a-row-is-selected.html
), I successfully completed my 3 week trail with my project. Thanks to all contributors especially to Neeraj.
There are very few suggestions, from the users to improve.
The data in columns C to K in the attached spreadsheet is mainly transferred from another workbook, using a macro in that workbook. There are times we need to manually type data in the same columns. Issue is, when data is transferred from another workbook, Column L is not populating the date. However, if we type in the data in the columns, then the date will auto populate.
Also if I protect the sheet, the date will not auto populate.
Any suggestions to overcome these two things.