Password Encryption VBA

[Doruli]

Hello,
I am running a program where I have a "Master" Workbook and a "User" Workbook. The Master Workbook is encrypted.
The "User" Workbook takes its values (via vlookup) from the "Master" Workbook. The problem I get is that if the "Master" Workbook is not open, then if one opens the "User" Workbook the password of the "Master" Workbook is required in order for the Vlookup connections to be updated.
Is there a way to program a Vba macro in the "User" Workbook to automatically insert the encrypted password each time the Input Dialogue box requests it?

(I need that as I do not want the users that are using the "User" Workbook to know the password of the "Master" Workbook")

Thanks
Dora

[zbor]

Define somewhere macro with password:

Please Login or Register  to view this content.

and then call it at beggining of each code you want:

Please Login or Register  to view this content.

[HaHoBe]

Hi, Doruli,

maybe have a look at the open-command:

Workbooks.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMru, Local, CorruptLoad)

You could add the command to the workbook_Open-event in ThisWorkbook. The VBA-Project of that workbook would need to be protected by password.

I´m not so sure that I may not use another workbook which will hold the data and would be created when clsoing the encrypted workbook.

Ciao,
Holger

[Doruli]

Thanks
However, is it a way where the User Workbook is open, the user press the section to update the links that are connected to another data source (i.e. the vlookup command connected to MASTER Workbook) then when the dialog box appears and asks for the password of the MASTER Workbook (in order to update the links) a VBA macro is automatically activated that inserts (without opening the MASTER Workbook) the encrypted password of the MASTER Workbook?

What I am after, is it any way that a Macro can detect the Opening of an Input Dialogue Box to insert a password and automatically fill the password?