View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
 
Posts: 184
Default Visual Basic Protection and Delete Modules

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