Protecting Table Conditionally
There is an Excel file that teaches how to perform the Protecting Table Conditionally operation.
Excel Format: Protecting Table Conditionally
This workbook demonstrates protecting table conditionally using VBA macros on a 63-row data layout.
Hope it is useful.