Hello,
I have zero experience with VBA but trying to learn. In the attached spread sheet I am trying to achieve the following through VBA. The sheet will be protected (blank password for the attached file)
1. Lock all cells in a worksheet except for the column where the date in row 1 is equal to current date +/- 2 days. Basically, on any given date, should allow data entry only in one column within 2 days of the current date.
2. I need the macro to work across all sheets in the workbook. The sheets could be named anything - not necessarily Sheet1 / Sheet2 etc.
Thanks a bunch in advance for your efforts.
Bookmarks