Recording a password by macro

Question

Hi there,I wonder how to protect a workbook with a password leveraging macro. I am looking for a method to utilize Record Macro to make it happen without using codes in VBA. I’ve tried several ways but none of them worked.Click Record Macro from the View menuSelect Store macro in as This Workbook / Personal Macro WorkbookSelect the Review menu &gt; click the Protect Workbook menuAdd Password (option) and Verify &gt; click OK (Keep the Protect structure check box selected)Moving back to the View menu and click Stop RecordingMoving back to the&nbsp;Review menu and click Unprotect WorkbookInput Password, then it works&nbsp;Click View Macros from the View menu, select the Macro name, and&nbsp; runSelect the Review menu and click Unprotect Workbook againThe password window doesn’t pop up, instead step #4 pops up&nbsp;The issue I’m encountering is that the password isn’t working for the second time and beyond. If there is no way to record a password by macro, but it’s possible to do by VBA, please let me know.

jmb17 · Accepted Answer

Toraji3&nbsp;&nbsp;No, the macro recorder does not record the password for the sake of security. If you look at the vba code the recorder creates, it&nbsp; should look something like this:&nbsp;&nbsp;Sub Macro1()
'
' Macro1 Macro
'

'
    ActiveWorkbook.Protect Structure:=True, Windows:=False
End Sub&nbsp;&nbsp;But, you can edit the macro to include the password:&nbsp;&nbsp;Sub Macro1()
    
    ActiveWorkbook.Protect Structure:=True, Windows:=False, Password:="ABC123"

End Sub&nbsp;&nbsp;

Forum Discussion

Recording a password by macro

2 Replies

Resources