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