Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
How to delete rows in visual basic | Excel Discussion (Misc queries) | |||
How to delete rows in visual basic | Excel Discussion (Misc queries) | |||
Delete Code Modules Programatically | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |