Macro that locks cells based on day of the week?

**91TwighlightGT** · 06-06-2012, 12:36 PM

Hello everyone,

I am trying to create a time-card using the excel spreadsheet. What I would like to do is make the spreadsheet only allow entries on certain days of the week. So, on Mondays only the Monday entries would be allowed, on Tuesday only Tuesday entries, etc. The reason for this is just to make sure that there are not mistakes when entering times (accidentally entering clock-in and clock-out times for Tuesday on Monday, for instance) and so that no one can go back and change a time at a later date.

Any help would be appreciated!