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.
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.