Posted by ecnirp on February 04, 2002 7:28 AM
I am linking one excel spreadsheet to another, using copy/pastespecial link. The file i am copying from is password protected on read/write, but i need to copy 3 cells from the sheet which are not sensitive (its a payroll spreadsheet). I know the password, but if anyone else uses the spreadsheet it prompts for the password. Is there anyway i can pass the password through automatically so the links work without prompting for the password.
Thanks in advance.