suppressing passwords to edit linked files
 

I have a Master workbook that is linked to two other workbooks. The two
source workbooks are password protected.
Since I am the only person with access to the Master workbook, I would like
to open it without having Excel ask me for the passwords for the two linked
workbooks.

Is this possible? Thanks,

--
tj

suppressing passwords to edit linked files
 

Maybe just having a 4th workbook that opens the two siblings and then the
parent.

You can supply the password in the code that opens the workbooks.

tjtjjtjt wrote:

I have a Master workbook that is linked to two other workbooks. The two
source workbooks are password protected.
Since I am the only person with access to the Master workbook, I would like
to open it without having Excel ask me for the passwords for the two linked
workbooks.

Is this possible? Thanks,

--
tj

--

Dave Peterson

suppressing passwords to edit linked files
 

Thanks, I'll give it a shot.

--
tj


"Dave Peterson" wrote:

Maybe just having a 4th workbook that opens the two siblings and then the
parent.

You can supply the password in the code that opens the workbooks.

tjtjjtjt wrote:

I have a Master workbook that is linked to two other workbooks. The two
source workbooks are password protected.
Since I am the only person with access to the Master workbook, I would like
to open it without having Excel ask me for the passwords for the two linked
workbooks.

Is this possible? Thanks,

--
tj

--

Dave Peterson