Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking to a Password Protected Document in Excel 2000
I have a document that is password protected. I also have a file that
references the protected files for many of the its formulas. Each time I open the file and update the links I am prompted multiple times (once for each cell reference to the protected file) for the password. Is there any setting so that a user is only prompted once for the password to a reference file that is protected? I know that one option is just to copy the tabs from my referencing file into the protected file, but it would be nice to keep the documents separate. Thanks, Andrew |
#2
|
|||
|
|||
One option might be to disable the prompt for the links. Go to Tools\Options
and click on the Edit tab. Deselect the "Ask to update automatic links" checkbox. "Andrew" wrote: I have a document that is password protected. I also have a file that references the protected files for many of the its formulas. Each time I open the file and update the links I am prompted multiple times (once for each cell reference to the protected file) for the password. Is there any setting so that a user is only prompted once for the password to a reference file that is protected? I know that one option is just to copy the tabs from my referencing file into the protected file, but it would be nice to keep the documents separate. Thanks, Andrew |
#3
|
|||
|
|||
Another option is to open all those password protected workbooks, then open the
"real" workbook. saved from a previous post: Maybe you could create a macro that would open all those workbooks first. Your macro would supply both the workbook's name and password. Then after all these workbooks are open, you could open the file that contains the links. Kind of like: option explict sub auto_open() dim wkbk1 as workbook dim wkbk2 as workbook dim wkbk3 as workbook set wkbk1 = workbooks.open(filename:="c:\a.xls",password:="one ") set wkbk2 = workbooks.open(filename:="c:\b.xls",password:="two ") set wkbk3 = workbooks.open(filename:="c:\c.xls",password:="thr ee") 'wkbk3 is the real one! wkbk1.close savechanges:=false wkbk2.close savechanges:=false 'thisworkbook.close savechanges:=false end sub (I'd create a 4th workbook that opens the files in order and just closes the first 2 and then itself.) Andrew wrote: I have a document that is password protected. I also have a file that references the protected files for many of the its formulas. Each time I open the file and update the links I am prompted multiple times (once for each cell reference to the protected file) for the password. Is there any setting so that a user is only prompted once for the password to a reference file that is protected? I know that one option is just to copy the tabs from my referencing file into the protected file, but it would be nice to keep the documents separate. Thanks, Andrew -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Excel should not delete document after trying to send email | Excel Discussion (Misc queries) | |||
linking an excel document to my task folder in outlook | Excel Discussion (Misc queries) |