Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code for Deleting a Row | Excel Worksheet Functions | |||
Deleting code from a macro (by a macro) | Excel Discussion (Misc queries) | |||
Deleting code in a file with code.. | Excel Programming | |||
visual basic macro code for deleting referenced rows | Excel Programming | |||
visual basic macro code for deleting referenced rows | Excel Programming |