Can I password protect VBA modules using a macro?

  • Thread starter Thread starter Don Wiss
  • Start date Start date
D

Don Wiss

Can I password protect VBA modules using a macro? I use a macro to prep
the workbook for release. It would be nice if password protecting the
modules could be part of this prepping routine.

Don <www.donwiss.com> (e-mail link at home page bottom).
 
If you try, you'll have to rely on Sendkeys.

Here's a Ron de Bruin post of a Bill Manville macro:
http://google.co.uk/[email protected]

I wouldn't rely on this.
Click to expand...

Most useful. Thanks. I'm not looking to bury a password in the code. I plan
to change it for each release. What I got out of the post was:

Sub LockCode()
SendKeys "+{TAB}{RIGHT}%V{+}{TAB}"
ActiveWorkbook.VBProject.VBE.CommandBars(1).FindControl(ID:=2578, recursive:=True).Execute
End Sub

Don <www.donwiss.com> (e-mail link at home page bottom).
 
Back
Top