• 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 Worksheets with Password Prompts

A

AJS_Pa

New Member
I want to restrict access to all individual worksheets except for one. I think I need to set the visible property of all the sheets (save the one) to xlsheetveryhidden and create the macros that would prompt the user for a password that would, if the password is correct for a sheet, make the sheet unhidden.
How do you do this or is there a better way to achieve the end result?
The workbook will have multiple users, each being allowed access to only a certain sheet(s) via passwords.

Thanks for your time & assistance.
 
You must log in or register to reply here.
Back
Top