Password required to view WB help

[SRC]

How do you password protect a workbook that requires a password to modify or even view sheets/data. I am writing a macro that sets a password for a set of spreadsheets each month and I only want people with the password to view the workbook. I dont want anyone without the password to be able to open it as read-only.

Idea...

On opening the target WB, set all sheets to hidden, then have a userform pop up and ask user for the password, if the password is wrong, then close the workbook.

I've read many posts about excels protect method, but I dont want anyone to be able to open it in read-only mode. Is there an way to remove the read-only option?


SRC

 

[Cbrine]

You can set a file level password.
Do file SaveAs... Select options and assign a password.
If they don't know the password, they can view the file.
This will not protect sheet contents from change if the person does have the password.

 

[SRC]

Thanks, just what I was looking for.