Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Add-ins to a Protected Project
I have some VB code in Excel that is used to search for and load
particular add-ins that may be present in the current directory. All was working fine until time came to password protect the original project (that loads the add-ins). Now the line: Application.VBE.ActiveVBProject.References.AddFrom File "filename" causes the user to be prompted for the VB project password. The code continues to execute past this point without problems regardless of whether the password is entered OR if the user just hits cancel. So, question is how to stop the needless VB password prompt? Any suggestions appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Add-ins to a Protected Project
I haven't tried to reproduce the problem but can't you just open the add-in
and skip setting a reference to it? If you need to call code in the add-in you could use Run. -- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading Add-ins to a Protected Project
Run is what is used next.
My point is that under all circumstances the code executes properly and the required add-ins are loaded, but when the main project is password protected the line mentioned previously causes the user to be prompted for the VB Project password. Since the password is not actually required (code executs fine if the user simply cancels the pw request) then how can I stop the prompt? Once again any help appreciated. "Jim Rech" wrote in message ... I haven't tried to reproduce the problem but can't you just open the add-in and skip setting a reference to it? If you need to call code in the add-in you could use Run. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protected project | Excel Discussion (Misc queries) | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
VBA project is protected | Excel Discussion (Misc queries) | |||
Password protected VBA project | New Users to Excel |