deleting code by macro
 

Hi there,

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

Lots of thanks

Jürgen

deleting code by macro
 

Hi Jürgen
See Chip Pearson's Progamming to the VBE section for tips:
http://www.cpearson.com/excel/vbe.htm

HTH
Cordially
Pascal

"jriehl" a écrit dans le message de
...
Hi there,

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

Lots of thanks

Jürgen

deleting code by macro
 

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


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"jriehl" wrote in message
...
Hi there,

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

Lots of thanks

Jürgen