Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Andrew
 
Posts: n/a
Default 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   Report Post  
Chad
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
bypass password when update linking of password protected file Yan Excel Discussion (Misc queries) 1 February 8th 05 12:29 AM
How to embed Word document into Excel and retain sizing, formatti. Kent Excel Discussion (Misc queries) 0 February 2nd 05 08:37 PM
Excel should not delete document after trying to send email 4rs Excel Discussion (Misc queries) 0 January 14th 05 05:39 AM
linking an excel document to my task folder in outlook hallbb1 Excel Discussion (Misc queries) 0 January 10th 05 05:07 AM


All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"