I have a password protected workbook (DataFile.xls) that I want to access
from File1.xls using a VLOOKUP function. When the user opens the File1.xls I
can avoid the update links by adding this line to an beforeworkbookopen event:

Workbooks.Open Filename:= "File1.xls", UpdateLinks:=3

But then the user gets prompted to enter the password. Is it possible to use
the beforeworkbookopen event to input the password. I don't want the password
entry to be manual.