Linking to External "Password Protected" Worksheet
I am linking to a cell in a protected worksheet to retrieve the data in that
cell. The command I am using is ='D:\directory\[spreadsheet
name.xls]Actuals'!$F$369.
Is there a way that I can embed the password into this command so that the
pop-up window doesn't always appear and request the password be typed in?
Thanks, Dave
|