Since you state that the control files begins to access the time sheets, I
assume you have a macro set up that initiates the action. Add a code snippet
to the macro that automatically provides the password to access the file, and
make sure to close the file once the information is retrieved/reconciled.

"0o0o0o0o" wrote:

I have 50 password-protected workbooks (time sheets) and a control file. Each
employee has his own file with unique password, supervisor is the only one
who can access control file and enter information that is compared to data
from individual time sheets and flags any errors. The problem I have is when
I open control file, it tries to access individual time sheets to get data,
and since every time sheet file is password protected, I have to enter 50
passwords. Is there any way around this? Note: every time sheet must be
password protected - privacy concerns.
Any help on this would be greatly appreciated.