Using Formulas on Protected Sheet
There is an Excel file that teaches how to perform the Using Formulas on Protected Sheet operation.
Excel Spreadsheet for Using Formulas On Protected Sheet
This workbook demonstrates how formulas function on a VBA-protected worksheet with a minimal 5-row layout and single formula cell.
Hope it is useful.