Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing code in 'This Workbook'
I am using Excel 97.
I am wanting to progammatically remove the code in the 'This workbook' module. Can anyone assist with some code please? Thanks -- Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing code in 'This Workbook'
Hi Mark,
See topic "Deleting All Code From A Module" from Chip Pearson's Site http://www.cpearson.com/excel/vbe.htm Regards, Shah Shailesh http://members.lycos.co.uk/shahweb/ *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing code in 'This Workbook'
Sub Rid()
With ThisWorkbook.VBProject.VBComponents("ThisWorkbook" ).CodeModule .DeleteLines 1, .CountOfLines End With End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Mark" wrote in message ... I am using Excel 97. I am wanting to progammatically remove the code in the 'This workbook' module. Can anyone assist with some code please? Thanks -- Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving & Removing VB Code from WB | Excel Worksheet Functions | |||
removing a toolbar with code | Excel Programming | |||
Removing Workbook_Open code | Excel Programming | |||
Removing VBA Code (programatically) | Excel Programming | |||
Removing a module with code | Excel Programming |