Visual Basic Protection and Delete Modules

[Jeremy]

I have in my visual basic the following code

' Deletes Modules
Set vbCom = Application.VBE.ActiveVBProject.VBComponents

vbCom.Remove VBComponent:= _
vbCom.Item("Module1")
vbCom.Remove VBComponent:= _
vbCom.Item("Module2")
vbCom.Remove VBComponent:= _
vbCom.Item("Module3")
vbCom.Remove VBComponent:= _
vbCom.Item("Module4")

This macro is held in module 8 and when the code is ran it works if visual
is unprotected but give run-time error 50289: can't perform operation since
the project is protected when the visual is protected.

How do I run this macro with visual protected?


Thank you

 

[Jim Thomlinson]

You are going to have difficutly with that one. You can not execute teh code
with the project locked and there is no truely effective way to unlock it...
check out the paragraph just above the bright red warning...

http://www.cpearson.com/excel/VBE.aspx

 

[JLatham]

The interesting thing is the hint about SendKeys. I actually tried that
approach a few weeks ago and got it to work (interesting security hole) in
Excel 2003 and even 2007 on Windows XP systems. However, there was an issue
in the way that the SendKeys were being handled in Excel 2007 on a Vista
system and I couldn't achieve the same effect (granting permission to access
the VBA Project) in that setup; the last keys needed to complete the sequence
didn't end up getting sent to the ribbon control as needed.

 

[Jeremy]

So is it possible for me to delete modules with visual being locked and how?


Thanks