Article ID: 214314 - View products that this article applies to.
This article was previously published under Q214314
This article has been archived. It is offered "as is" and will no longer be updated.
This step-by-step article describes how to open a document that is linked to password-protected sheet in Microsoft Excel 2000.
If you open a Excel worksheet that is linked to protected worksheets, you are prompted whether to update links to unopened worksheets. If you click Yes, you are prompted for the passwords of the linked documents.
If the original document is opened with a macro, you can include an argument to suppress the "Update Links" dialog box; however, there is no argument that allows you to supply passwords for closed, linked documents.
If you have limited programming experience, you may want to contact a Microsoft Certified Partner or Microsoft Advisory Services. For more information, visit these Microsoft Web sites:
Microsoft Certified Partners - https://partner.microsoft.com/global/30000104
Microsoft Advisory Services - http://support.microsoft.com/gp/advisoryservice
For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
To open password-protected links, you must open the linked documents first. If you open the linked sheets first, the dialog box that asks whether or not to update links to unopened documents does not appear. The following example macro opens a linked document (Test2.xls) that is protected by the password "test", followed by the original document (Test1.xls):
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.