Protecting Cells, Autofiltering, List Objects and VBA

Looking for a bit of help please?

I have a spreadsheet that basically allows users to input a number of data fields into it, names, numbers etc. It runs on a dynamic list object table that automatically populates todays date into Column A, and then allows the user to input 7 other cells B-J. It then runs through a series of calculations to check for duplicate values throughout the spreadsheet and formats the cells accordingly using colour. It also adds three other cells to RAG the entry to inform the user if they need to double check the entry or not. It performs the calculations through the worksheet change events.

The worksheet i set to autofilter to the last 10days worth of entries.

I have one major issue in that if the user deletes the prepopulated date in column A then the code bugs out, and hides the row. Assuming because the autofilter fails?

I have done some reading to see about protecting the column / cells but it doesn't seem that straight forward and im going round in circles...

I guess i'm left with two options unless someone can come up with something to help, educate users (not easy!) or look at protecting the cells somehow, using some sort of data validation / object box for data entry? Any help / suggestions would be greatly appreciated? The nature of the workbook doesn't allow me to upload it, but i have attached the code but changed the named ranges etc... please go easy, i'm a VBA newbie ;-)

Thanks

Please Login or Register  to view this content.