I have a workbook with eight worksheets. I want to add a vb command button to unlock the password protected workbook and five of the password protected worksheets and then go to a custom view. However, since many people will have access to the workbook I need it to prompt for a password before running. I don't want the password to be read from the code and run automatically.
I hope this makes sense. Thanks in advance.