caramel_delight
New Member
- Joined
- Dec 24, 2020
- Messages
- 4
- Office Version
- 2011
- Platform
- Windows
HI
I want to run this so it deletes modules 1,2,3, etc for all open workbooks
At this moment this runs just the workbook i am in
Sub DeleteThisModule()
Dim vbCom As Object
Set vbCom = Application.VBE.ActiveVBProject.VBComponents
vbCom.Remove VBComponent:= _
vbCom.Item("Module1")
End Sub
Any suggestions ?
I want to run this so it deletes modules 1,2,3, etc for all open workbooks
At this moment this runs just the workbook i am in
Sub DeleteThisModule()
Dim vbCom As Object
Set vbCom = Application.VBE.ActiveVBProject.VBComponents
vbCom.Remove VBComponent:= _
vbCom.Item("Module1")
End Sub
Any suggestions ?