Dec 18 2022 03:38 PM - edited Dec 18 2022 03:40 PM
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 row of each column.
Dec 19 2022 02:49 AM
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).