Storing a Password to open a file in Personal XLA

[DoctorV3774]

We have a sensitive workbook we send to many users in our organization. Certain users should always be able to open it. It prompts for a password on open. What I wanted to do was to store a macro in these specific users Personal XLA that any time a workbook opens with a Password Prompt it automatically fills in the password and/or opens the workbook for them without them having to remember what the password is. We just wanted to distribute some sort of macro that they store on their Personal XLA that says on Password Prompt fill in the word TopSecret

Is there any way to do this?

Thanks

 

[01Patrik]

To the best of my knowledge there isn't any event that is started upon opening of another workbook.

However, a way to get around this:

a workbooks_open event in the file that promts for password, that states that some usernames are excluded from the password prompt:

if not application.username = "01Patrik" then

{your password prompt}

end if

This is not totally secure since people can change their username, but if no-one tells about the functionality, no-one will know as long as you password protect the VBA project.

// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.