Vba Login Excel. We have come across systools vba password remover tool to unlock password protected word doc file. With a simple editor again open the excel file you don t know the vba password for.
Step 2 on the new window click on the select a file button and follow the on screen instructions to upload the excel vba password protected file into the program s interface. Click here to learn more about adodb connection. Create a new simple excel file.
With a simple editor again open the excel file you don t know the vba password for.
On the file tab click the options button. Sub vba project password dim mypassword as variant dim password as string password 123 mypassword application inputbox enter your password password required to run the macro if mypassword password then range a1 value this is a vba project password enabler else msgbox incorrect password end if end sub. The following figure shows the customize ribbon in excel 2010. We restrict the user to the data which is meant for him her.
