Emiljano Qorraj
New Member
Hello,
Can anyone please help me with this case?
I am trying to make a vba code to unlock an excel reference only if a cell reference meets a criteria.
I have a sheet with dates in range A2:A32. I want the vba to check if the date in this rage is today's date, then unlock a specific range at the same row.
For example: If A27 is today's date, then unlock B27:K27. All the other cells of the sheet must remain locked.
I will appreciate any help.
Thanks in advance.
Can anyone please help me with this case?
I am trying to make a vba code to unlock an excel reference only if a cell reference meets a criteria.
I have a sheet with dates in range A2:A32. I want the vba to check if the date in this rage is today's date, then unlock a specific range at the same row.
For example: If A27 is today's date, then unlock B27:K27. All the other cells of the sheet must remain locked.
I will appreciate any help.
Thanks in advance.