I need to open a workbook and have it ask the user for a password. If they
know the password then they can use the workbook, however if they do not know
the password then they can only view what the workbook has in it.
The workbook has a lot of code in it and creates sheets automatically but
there will only be a couple of users that will actually enter data, the rest
will just need to view the information entered without the ability to make
any changes. Is there a way to do this when the workbook opens?