Hiding and Encrypting Sheet
There is an Excel file that teaches how to perform the Hiding and Encrypting Sheet operation.
Excel Hiding and Encrypting Sheet
This workbook hides worksheets and applies password protection using VBA across four sheets.
Hope it is useful.