Hi,
Is it possible to have some code that will unlock the VBA password for viewing VBA modules? The reason I ask, is because I am writing some code to import/export modules (for updating purposes), but I would like to password protect the code. However, you cannot import/export modules if viewing is password protected as far as I know.
I tried to Google this, but to no avail. I would appreciate if anyone could shed some light on this matter.
Thanks.
May be possible with a send key method but not reliable. It's the only way i'm aware of. Feel free to look at this:
Click Here
Shelton A.
If Helpful, Add Reputaion!
According to this site:Programming The VBA Editor; "There is no programmatic way to unlock a VBA project (other than using SendKeys). If the project is locked, you must manually unlock. Otherwise, the procedures will not work."
Perhaps it would be better to save the modules as an Add-In which can be password protected and you can add\remove the entire Add-In programmatically without unprotecting the modules.
If you do a web search for something like Creating an Excel Add-in, you'll find several guides.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks for the suggestions and information. I appreciate it! I will try to work on an Add-In as suggested. Have a great day.
It is possible without SendKeys using API calls: http://www.vbaexpress.com/forum/show...ewing-SendKeys
Remember what the dormouse said
Feed your head
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks