brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I have a password protected worksheet which when I open enters the day of the month in cell c1 (This is a formula in cell C 1 which just gives the date by today but showing the day only)
I then have columns where in row 2 I have the column header for each day of the month (1 - 31)
When I open the worksheet I want to unprotect only the column for the current day of the month
This is so the employee can enter information in the column for today but cannot go back and change historical information.
When I leave the sheet it must protect everything on the sheet again.
Can you help with this code.
I then have columns where in row 2 I have the column header for each day of the month (1 - 31)
When I open the worksheet I want to unprotect only the column for the current day of the month
This is so the employee can enter information in the column for today but cannot go back and change historical information.
When I leave the sheet it must protect everything on the sheet again.
Can you help with this code.