Lock unhide sheet in a workbook with a password

[vikosh]

Hi,

Is there a way to make sure that only i can unhide one of the worksheets in a workbook using a password?

I have two worksheets. One of them is hidden, but i'd like to lock it with the password. I wouldn't like to have any password prompts when other users open the workbook, but rather the password prompt when someone tries to unhide the hidden worksheet.

Is this possible? Probably with VBA?

Thank you in advance,

 

[Peter_SSs]

Hide the worksheet and then Protect Workbook (with password) on the Review ribbon tab?
To unhide the worksheet you would first Unprotect the workbook with your password & then unhide the worksheet.

 

[offthelip]

Another way you could do it is to make the worksheet Veryhidden which you have to do with VBA and then password protect the VBA project for that workbook, This would allow you to still Protect the workbook without a password if you wanted to