Excel VBA code to unlock developer password

[macca_18380]

Hi and thank you in advance,

Is it possible to have create a VBA code that unlocks a password set in developer?

Thank you
Michael

 

[Michael M]

Hi Michael
This forum doesn't support or provide information regarding password manipulations, but yes it is possible. !

 

[macca_18380]

Thank you for your response and i'm sorry, i should have been more clear. It's a password that i know and have set, i want to run a macro that unlocks my password, unhides all sheets so that calculations and updates can take place, and then when the calculation is finished to re-input the password and protect the workbook again. Is that possible to discuss on this forum?

 

[Fluff]

Is that possible to discuss on this forum?

As long as you know the password, that's fine.

 

[macca_18380]

As long as you know the password, that's fine.

Thank you, so if my password was "1234", is there code to use this password to unlock and re-lock developer?

 

[Alex Blakenburg]

There isn't really a concept of unlock and re-lock developer, I think you mean protect the workbook structure.
Try this:
(Note: ThisWorkbook is the workbook with the code in it. If that is not the case perhaps use ActiveWorkbook)

Sub ProtectUnprotect()
    ThisWorkbook.Unprotect Password:="1234"
    ' -------------
    ' do something
    ' -------------
    ThisWorkbook.Protect Password:="1234", Structure:=True
End Sub

 

[macca_18380]

Hi Alex,

Thank you for your suggestion, this is my fault, i'm not being clear enough. I ran the macro as you suggested and afterwards i hit right click on the tab to view code for the particular sheet i am working on and I was met with the VBA Project Password box, this is the password box i'm trying to enter my password into...any ideas on how to do this?

Thank you
Michael

 

[Alex Blakenburg]

How did you add the code I gave you ? You would have had to enter the password to enter the code.
There should be nothing your macro needs to do that requires the VBA project to be unlocked.
If you want to change the code just manually unlock it by entering the password.

 

[macca_18380]

How did you add the code I gave you ? You would have had to enter the password to enter the code.
There should be nothing your macro needs to do that requires the VBA project to be unlocked.
If you want to change the code just manually unlock it by entering the password.

I added it into a module, changed the password to my password, and assigned it a button and ran the macro. Afterwards i ran my calculation macro but i got this error which i presume has something to do with a tab that i have hidden. I have hidden tabs in the workbook by using the xlveryhidden option in the properties section of the VBA Project. So ideally i need to automatically unlock and change the Visible option to xlsheetvisible for all hidden worksheets.

 

[Candyman8019]

In your macro you'll need to unlock the sheet and unhide the sheet...then rehide it before the sub ends.

    Sheet14.Unprotect Password:="1234"
    Sheet14.visible = xlSheetVisible
    ' -------------
    ' do something
    ' -------------
    Sheet14.visible = xlSheetVeryHidden
    Sheet14.Protect Password:="1234"