Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import module in protected project?
Chip Pearson wrote: Rob, For the Unprotect operation a much simpler way is simply use code like the following: Sub UnprotectVBProject(WB As Workbook) Set Application.VBE.ActiveProject = WB.VBProject In Excel 10.0, this above does not select the project of an XLA addin in the Projects window. Tried by running the UnprotectVBProject sub routine from within VBE and also from excel Run macro dialog box but to no avail. Also the Application.VBE.ActiveProject help file indicates that this is now a readonly property. So, Microsoft now seems to have permanently fixed the unlocking of VBE Projects via VBA! Right? SendKeys "~PASSWORD~" End Sub Of course, change "PASSWORD" to the actual password for the project (but keep the leading and trailing ~ characters -- these represent the ENTER key). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning the Help 4, *.HLP file for a project programmatically in a protected Project | Excel Programming | |||
Accesing vba project from wb that has vba project password protected | Excel Programming | |||
Module Names within a Project | Excel Programming | |||
Remove VBA Project module | Excel Programming | |||
Import module with vba | Excel Programming |