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.