VBA - autotype file password

Question

I have 2 excel workbooks: WB1 (password protected) and WB2. WB2 takes some data from WB1. Everytime I open WB2 i need to type password to WB1 file. Is it possible to make VBA code that type password everytime I open wb2?

You would have to put it directly in the code. I assume your workbook is password protected for reason. Placing the password in another document that is not password protected would not be a best practice, in my opinion. — Brent
– Brent, Commented Aug 20, 2018 at 13:51

Marcucciboy2 · Accepted Answer · 2018-08-20 19:56:03Z

1

Yup, and it's actually pretty easy! In workbook 2 you would add this code here to accomplish what you're looking for

Private Sub auto_open()
    Workbooks("workbook 1 name").Unprotect PASSWORD:="my password"
End Sub

Private Sub auto_close()
    Workbooks("workbook 1 name").Protect PASSWORD:="my password"
End Sub

I added the code to re-protect it once you close the second workbook but you might instead want it to be protected under other circumstances, so it's not exactly required.

You should also consider only having workbook 2 unprotect the first workbook during the time that it needs to pull data from workbook 1.

edited Aug 20, 2018 at 19:56

answered Aug 20, 2018 at 13:53

Marcucciboy2

3,2673 gold badges22 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kubie Over a year ago

Suggestion, if you hardcode your password into the VBA program, I would suggest going to Tools > VBAProject Properties > Lock Project

Collectives™ on Stack Overflow

VBA - autotype file password

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related