Thank you for the response Kimberly, but that ONLY allows the people with passwords to open the file at all. Everyone without a password needs read-only access, and again if we 'unprotect' with a password I want the workbook to close automatically protected.