Hello Everyone.

I need some help. I will explain the situation first and then the question.

I have a folder. In this folder i have 14 Excel 2003 files. One is the
controler called Main.XLS. So this automatically opens when windows loads. To
open it fully a password is needed. Enter the password and you can access,
via links, to the other 13 Excel files and back again to the Main file.

The question....Is it possible to password protect the other 13 files so
that if they are opened directly from the folder they are in, you have to
enter a password, however, if you use the Main xls file, you dont need to
input a password as access has already been granted. Because of the system i
have created, i need quick access once the password is entered into the Main
xls file, without being asked for a password every time i go into one of the
other 13 files. But still have security so that if they are opened indivually
users are asked for a password! i hope this makes sence. I have had to break
the Main file down. I have everything in one work book with over 400 sheets
and the system was unbelievably slow.

Any help or VBA code would be great to help me solve this.

Regards