Benforest1
New Member
- Joined
- May 25, 2022
- Messages
- 3
- Office Version
- 365
- 2016
- Platform
- Windows
Hey,
I have a very complex file, lots of VBA that i have taken over from someone else. I am trying to lock Column E8:E100 if the cell is not blank on a milestone tab (e.g if there is text in column E8:E100 lock the cell so no one can change it. I have tried lots and cant get it working!
I have separate VBA to lock and unlock the worksheet.
Any help much appreciated
Thanks,
I have a very complex file, lots of VBA that i have taken over from someone else. I am trying to lock Column E8:E100 if the cell is not blank on a milestone tab (e.g if there is text in column E8:E100 lock the cell so no one can change it. I have tried lots and cant get it working!
I have separate VBA to lock and unlock the worksheet.
Any help much appreciated
Thanks,