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