hi all,
the boss has asked me to see if it is possible to just allow users to enter data and not let them delete any. my question to you is: in your experience is it better to use the protect sheet function or is there some vba events (like worksheet_change or worksheet_selectionchange) that suits the request better? i have used the worksheet selectionchange event before and really dont think that is the way to go as there will be multiple cell entries and dont want to have to go thru checking it with every cell. i have not used the worksheet change event so not sure what to expect there. any ideas?
this is just a simple spreadsheet with no formulas, just text.
thank you for your time.
erik