Re: Password in linked workbook

Giganews Newsgroups
Subject: Re: Password in linked workbook
Posted by:  J.E. McGimpsey (jemcgimps…@mvps.org)
Date: Thu, 23 Oct 2003

Check out the Open method in VBA Help: it will show you how to use
the password argument when opening a file.

Nothing you put in the password-protected workbook (i.e., the
Workbook_Open() event) will help you since the workbook won't open
unless the password has been given.

In article <ec3bkWRmDHA.24…@TK2MSFTNGP10.phx.gbl>,
"rob nobel" <robnob…@dodo.com.au> wrote:

> Hi,
> I have a workbook linked to another workbook that has a password.  Is there
> some code I can put into the workbook open() event that will bypass the
> request to enter the password?

Replies

In response to

Password in linked workbook posted by rob nobel on Thu, 23 Oct 2003