• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hide/protect sheet from viewing

momcaro

Member
Hello,
Is there a way to password protect a worksheet within a file so that only users with the password can see it? I know it can be done at the workbook level and you can protect sheets from editing, but how about viewing?
Thank you.
 
You can hide the relevent sheets and then Password Protect Workbook with "Structure" checked in. This way all users are required to unprotect workbook if they want to unhide the hidden sheets.

Thanks/Ajesh
 
Back
Top