Unprotect the sheet in VBA before working on it, the protect it afterwards

HTH

Bob

"Matt" wrote in message
...
I'm programming a tool for work that is comprised of several different
spreadsheets. There are about 15 individual spreadsheets on a networked
drive and a master spreadsheet that takes and compiles data from the other
15.

The issue I'm running into is that each of the 15 individual spreadsheets
is
password protected, so that only the owner of that spreadsheet can access
it.
I've created a macro on the master spreadsheet that will retreive the data
from each of the individual spreadsheets, but each time it attempts to
pull
data, it asks for the password.

Is there a way to bypass the password in Visual Basic so that the master
spreadsheet can compile the data from each of the individual spreadsheets
without it asking for a password? Any help or suggestions would be
appreciated.