How to autolock cells after specific hours passed & trigger autosave on protected sheets

Hi guys,

I'm trying to change the unlocked cells in columns B & D to locked cells, XX hours after data was entered in cells under column B.

I also want to trigger the workbook to autosave at a specific time of the day (will too many autosave instances crash the file ?).

I've looking over the internet for codes that might be relevant, but I can't seem to find the correct ones that can work with the current codes in my workbook.

I've pieced together the current codes after looking through various excel forums for my workbook to track staff attendance (a little messy as I'm new to VBA).

Workbook VBA

Formula:

Please Login or Register  to view this content.

Hope that someone could help me with this & enlighten me if the codes are likely to clash and not run at all (workbook is opened 24/7).

I'm also trying to disable the Share Workbook feature in the ribbon (any ideas on how to do it ?)

Thanks a lot. :D

Anyone knows if it's possible to switch the cell status to locked, hours after data was entered ?