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
--
HTH...
Jim Thomlinson
"Jeremy" wrote:
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