How can I enter a workbook password automatically

's Computer Specifications

Hi
I have a set of 6 user workbooks each of which is uniquely passworded (one
worksheet in each).
I then have a "master" workbook, which is also uniquely passworded, that
links to each of the 6 user workbooks to gather the worksheet information
into one place.

When the master is opened, Excel asks for the master password (which is
fine) but it also then asks for each of the 6 user workbook passwords.
Can I code the 6 usere workbook passwords into the master to save entering
them everytime? Perhaps by macro or something?

's Computer Specifications

The prompt happens before any macros run, so I would see no way to do what
you want.

--
Regards,
Tom Ogilvy

"Lainer" wrote:

> Hi
> I have a set of 6 user workbooks each of which is uniquely passworded (one
> worksheet in each).
> I then have a "master" workbook, which is also uniquely passworded, that
> links to each of the 6 user workbooks to gather the worksheet information
> into one place.
>
> When the master is opened, Excel asks for the master password (which is
> fine) but it also then asks for each of the 6 user workbook passwords.
> Can I code the 6 usere workbook passwords into the master to save entering
> them everytime? Perhaps by macro or something?

's Computer Specifications

There is presumably some code in the workbook_open event that is opening
these secondary workbooks. You can add the password using something like:-

Set mybook = Workbooks.Open(Filename:=MyPath & MyFiles(Fnum), _
Password:="MyPassword")

If you post the code then it would make things easier.

Mike

"Lainer" wrote:

> Hi
> I have a set of 6 user workbooks each of which is uniquely passworded (one
> worksheet in each).
> I then have a "master" workbook, which is also uniquely passworded, that
> links to each of the 6 user workbooks to gather the worksheet information
> into one place.
>
> When the master is opened, Excel asks for the master password (which is
> fine) but it also then asks for each of the 6 user workbook passwords.
> Can I code the 6 usere workbook passwords into the master to save entering
> them everytime? Perhaps by macro or something?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Enter in a workbook and copy to another automatically	=?Utf-8?B?U2hhdW4gaw==?=	Microsoft Excel Programming	2	1st Nov 2007 09:09 PM
Automatically enter password	=?Utf-8?B?TmF6?=	Microsoft Excel Programming	2	16th May 2005 12:50 AM
Automatically enter Password in Macro	Pepe	Microsoft Excel Programming	1	15th Jan 2004 06:21 PM
Please need HELP - Need to add and INPUT BOX so that users need to enter a PASSWORD to use a workbook	Marcello do Guzman	Microsoft Excel Programming	2	9th Dec 2003 05:30 PM
one line macro to enter password for workbook	N Lenox	Microsoft Excel Programming	5	29th Oct 2003 08:36 PM