NoviceJESS...
I have 6 workbooks. 5 of the workbooks are password protected to read and
modify because they contain very confidential payroll info. The 6th
document
is a rollup doc that's linked to the other 5, but doesn't need to be
password
protected, because the numbers are an aggregate - no sensitivity required.
When users go into the 6th document, they are asked to input 5 passwords -
which is a huge pain in the butt - is there a way to bypass these
passwords
(without having to "cancel" out) and still have the information update?
thank you, Jess @ Lifetime Fitness

Hi Jess,

Yes, you can write a quick vba routine to open all five password protected
workbooks. But I don't think you want to open the confidential workbooks,
or do you?

If the 6th workbook contains links the prior five, does it not contain the
data from the prior five already?

I guess I am not clear on ~exactly~ what you are trying to do.

If you can be specific as possible (including workbook names) as to what you
are doing and what you want to accomplish, then someone will give you step
by step instructions and will likely write a small vba routine to do
whatever needs done. The vba (visual basic for applications programming
language should be very small, so it ought to be pretty easy.) Please
describe your process in more detail.

Regards,
Kevin