deleting macros

  • Thread starter Thread starter SLG
  • Start date Start date
S

SLG

Is there a way to delete ALL macros from existing Excel
workbooks without deleteing each one individually?
 
SLG,

Requires a reference to the MS VBA extensibility, and acts on the
activeworkbook, but that is easy enough to change:

Sub RemoveAllVBACode()

Dim myVBA As VBIDE.VBComponent

For Each myVBA In ActiveWorkbook.VBProject.VBComponents
If myVBA.Type = vbext_ct_Document Then
With myVBA.CodeModule
.DeleteLines 1, .CountOfLines
End With
Else
ActiveWorkbook.VBProject.VBComponents.Remove myVBA
End If
Next myVBA
End Sub

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting a Macro on a Mac using Excel 2004 1
Removing disabled Macro 6
Link To File That No Longer Exists 1
Macro warning - how to delete macro 3
Collapsing all groups 0
Macro/Forumula to SUM values from Sheet that does not always exist 1
VBA to sidestep popups... 4
Removing Macros 4

Back
Top