Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I password protect VBA modules using a macro?
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). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I password protect VBA modules using a macro?
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/groups?threadm=u...GP09.phx .gbl I wouldn't rely on this. Don Wiss wrote: 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). -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I password protect VBA modules using a macro?
On Mon, 28 Mar 2005, Dave Peterson wrote:
Don Wiss wrote: 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. 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/groups?threadm=u...GP09.phx .gbl I wouldn't rely on this. 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).FindCo ntrol(ID:=2578, recursive:=True).Execute End Sub Don <www.donwiss.com (e-mail link at home page bottom). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protect Macro - Compile Error | Excel Discussion (Misc queries) | |||
Add protect worksheet password in macro | Excel Worksheet Functions | |||
Password protect macro | Excel Programming | |||
protect sheet macro - can't have it enter password | Excel Programming | |||
Request password during Protect macro | Excel Programming |