Forum Discussion
Locking a column based on a cell value in the same column
Hi there. Appreciate any assitance that works. Thanks in advance I wish to lock and unlock fixed rows in each column in a spreadsheet for any editing (including delete) based on a value at the top r...
See the attached workbook. Since it contains VBA code (in the worksheet module), users will have to allow macros when they open it.
The worksheet has been protected, currently without a password. If you want to set a password, you can change it in the code (right-click the sheet tab and select 'View Code' to view and edit the VBA code).
many thanks