Macro to help oepn the file without prompting fopr passwords
 

I have a fmaster file which is connected with 4 other files. All those
4 files are password protected. When i open my master file , it prompts
me to enter the passwrod for all the 4 files one by one to update the
data.
Is there a way to create a macro which helpms me not enter the
passwords manually one by one..

thanks