I am looking for a way to password protect certain worksheets from viewing.
I have sales totals in one sheet and sales commissions in another. I want the "commissions" sheet to be password protected so that if anyone clicks on the bottom tab they will be prompted for a password.
Press ALT+F11 to goto VB Editor
select your sheet and then for its properties "visible" make it to xlsheetveryhidden
then password protect your VBA going to Tools>>VBA project properties>> Protection