Macro to remove password from project code

[Sahak]

Hi All,

I would like to have a macro which before closing Excel, will unprotect Excel project Code (I know password) with Excel VBA code, to be clear, to run a macro which will unprotect Excel project Code.

Thank you in advance

 

[Nine Zero]

Hello,

How about this?

Sub sbUnProtectSheet()
ActiveSheet.Unprotect "password"
End Sub

 

[Sahak]

Thank you for your reply, but I need macro not for sheet or workbook, I need it for project.

 

[Macropod]

Hello,

How about this?

Sub sbUnProtectSheet()
ActiveSheet.Unprotect "password"
End Sub

That code unprotects a worksheet, not the VBA project. VBA does not provide a VBProject.Protect method or VBProject.Unprotect method. All that's available is SendKeys, which is rather unreliable for such work.

 

[Fluff]

Take a look at this thread
https://www.mrexcel.com/forum/excel-questions/59402-code-unprotect-vbaproject.html#post276912

 

[Sahak]

Thank you Paul very much.

 

[Sahak]

Thank you Fluff very much.

 

[Fluff]

Thank you Fluff very much.

You're welcome