Temporarily unlock VBAProject password to run code

Sargad_Strut

New Member
Joined
Mar 28, 2014
Messages
39
Hi Experts,

I have a number of workbooks (20+) that are being used by multiple users, and the code is password protected in order to hide sensitive information. Currently, I'm working on implementing a UserForm, that will be the same for all workbooks. The form is be imported on open, and that way I only need to make changes once, instead of doing it for all workbooks one by one. Everything went fine until I password protected the VBA code, which won't allow me to import the form. The solution that comes to mind would be to remove the password, import the form, and then password protect the VBAProject again.

Anyone know if this can be done, or have other suggestions on how to solve this problem? Solutions involning Extensibility are not feasable.

Any help is greatly appreciated.
 

Sargad_Strut

New Member
Joined
Mar 28, 2014
Messages
39
If those 20 workbooks share the same VBA I would opt for moving the code to an add-in. Updating an add-in is easier as there is only one file left to update rather than 20. All it takes is replacing the add-in. See: Excel: Building an Excel add-in and Excel: Update An Addin
Hi Jan,

Thank for your quick reply.

The 20 workbooks all contain different code, and also different passwords. The 'centralized' UserForm I am working on will be used as a standardized prompt to enter ODBC-credentials, and I just thought that it would be a nice feature to load it upon open every time, as that could spare me some headache in the future if things change. I was thinking something like this:

VBA Code:
Private sub Workbook_open()

'code to remove password
call loadUserForm
'code to set password again

End Sub
Right now I leaning towards just having control over some of the items on the form externally, but will look into the use of add-ins in any case.

Thanks again!
/Tobias
 

jkpieterse

Well-known Member
Joined
Dec 3, 2007
Messages
965
You could place the userform (and supporting code) in an add-in and create a reference in your other files to this add-in and then show the form from the other workbooks. But I think this adds to the complexity of your project rather than making it simpler.
 

Forum statistics

Threads
1,082,360
Messages
5,364,927
Members
400,815
Latest member
Joaquin Phoenix

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top