deleting code by macro

  • Thread starter Thread starter jriehl
  • Start date Start date
J

jriehl

Hi there,

is it possible to delete all of a workbooks code automatically by means of a
macro?

Lots of thanks

Jürgen
 
Later versions of Excel have Macro Security which prevent this sort of
activity without having been trusted.

Sub test()
Dim vbc As VBComponent

For Each vbc In ActiveWorkbook.VBProject.VBComponents
vbc.CodeModule.DeleteLines 1, vbc.CodeModule.CountOfLines
Next
End Sub
 
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

Run Macro If Cell have "x" value 0
Remove Hyperlinks Without Changing background shading 14
Automatically Saving created FILE 1
Skip Run macro if module has been deleted 1
Macro to delete part of a macro 1
Macro code for clicking on Command Button in another workbook 7
delete macros by macro 3
path to macros being changed 6

Back
Top