Visual Basic Protection and Delete Modules

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

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
 
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.
 
Back
Top