Locking and Unlocking Sheet
There is an Excel file that teaches how to perform the Locking and Unlocking Sheet operation.
Excel Locking and Unlocking Sheet
This workbook demonstrates locking and unlocking sheet using VBA macros on a 27-row data layout.
Hope it is useful.