VBA To Open A Password Protected Worksheet

[DummYBeaR]

I have 2 files. Worksheet A and Worksheet B. Worksheet A is protected by password but have some data that is linked to Worksheet B. How do I enable Worksheet B have the data updated without manually key in the password which is prompted every time when I open Worksheet B? Please guide me where to place the code. ThisWorkbook? Sheet? Class Module? Module?

[Sc0tt1e]

Please Login or Register  to view this content.

[DummYBeaR]

Where should I put this code? By the way, does the sheets code apply same for workbook & worksheet as well?

[Sc0tt1e]

Oh workbook might be a bit different. You'll have to declare the filepath as a variable and then the sheet range. I think it should look something like the below code.

Add the Unprotect before and code and then Protect after the code that way the sheet will be unlocked before the code is run and then locked when the code has finished.

Please Login or Register  to view this content.

[DummYBeaR]

I'm confuse now Maybe I did not get my question asked correctly. Here is the problem again with better explanation.

I have 2 files.

File A as Master & is protected by password if were to open
File B as Secondary which is getting part of data from File A

Every time when I open File B, a window will appear & request for password to access File A. I have to manually key in the password to get the data updated. If I disable File A password protection, opening File B will not have any problem updating the data. No window will prompt requesting for password.