View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dave1030 dave1030 is offline
external usenet poster
 
Posts: 1
Default 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