Creating a password protected, Read Only file

I have some excel files that are located on a common drive at work. They are riddled with VBA and have the individual sheets and workbook itself protected against reformatting and changing formulas. I was wondering if there was a way to have the file open with a box asking for a password or Read Only option. I would like the password to be modified only by a certain user, namely the one with access to unprotect the rest of the file. I want the password to grant access to the document for data entry but once the file is closed the password must be re-entered in order to open the file again. The password must not be able to be changed by just anyone. If it is to be tied to a certain username or embedded within the VBA that is fine. Does any of this make sense to anyone?

Thank you. I appreciate it.