User Form Password Question

[qiqinuinaifen128]

Hi,

Before i start, thank for visiting this threat.

Background
I have 3 Exel files. For example, the file names are A, B and C. A and B file is a date file, and the C file which i use it to summarize the A and B file, so each time when i open the C file , C file will take the data from A and B file by extracting A and B file.

For the security purpose, i have created two userform for the A and B file, so every time when people want to open A and B file. They have to key in the password in order to see the data of A and B file. On the other hand, when people open the C file, it will request the two password before it take data from the A and B file.

Finally, my question is what should i do, when the user open the C file and it will not ask the password.

Thank for you helping

[RobDog888]

Why wont it ask for the passwords? Are you prompting from a VBA macro or from Tools > Options > Security tab?

[qiqinuinaifen128]

Thank for your reply^_^

Reasons for not asking password is because of if the data file have 100, i have to enter 100 time of different password to see the summary.

The password is prompting from macro, not the excel itself.

[RobDog888]

Sounds like you have placed a passowrd on a cell or range, not the file? Can you describe in more detail?

[qiqinuinaifen128]

Yes, i place my password on range.

Thanks for your reply. Since my english is not good. But i will try to explain my scenario again.

i have 3 workbooks, for example wrk1, wrk2, and wrk3. wrk1, and wrk2 are the data source file, and wrk3 is the summary of the wrk1 and wrk2(which mean when opening wrk3, it will activate wrk1 and wrk2 and take the data from them.)

Since wrk1 and wrk2 need password to access, so that when opening wrk3, it needs the password for the wrk1 and wrk2 also. it will pup up an user form(which is i create myself) for user to key in password.

What i want is when the user open the wrk3, the wrk3 program will help the user fill in the password. So that the user of the wrk3 no need to remember the password for wrk1 and wrk2.

or

do you know what is the code for filling in the textbox for another workbook.(for example when i open wrk3, it will activate wrk1, so that the userform pup up and ask for password, the place for the user key in the password is textbox1, can i write the code in wrk3 like Activate.workbook.textbox1="password"

[RobDog888]

But this "password" feature is already built in and works better. Tools > Options > Security tab.

[qiqinuinaifen128]

Yes you are right, but one of the workbooks, i have more than onne password. So that i have to create my own user form and place the password on cell.

[RobDog888]

Well then you have to make sure macros are enabled or they can pen the book without a password.