Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Using the following code I can remove the VB code contained in ThisWorkbook. With ThisWorkbook.VBProject.VBComponents("ThisWorkbook" ).CodeModule .DeleteLines 1, .CountOfLines End With Is there a way that I can specify to remove only the Workbook_Open portion of the ThisWorkbook code? Example: "Private Sub Workbook_Open()" <some code End Sub The rest of the code in ThisWorkbook I'd like to leave untouched. Can this be done Thanks, Paul -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I: If Pie Section Label = X, Make Pie Section Color = Y | Excel Programming | |||
Remove end folder from path found with ThisWorkbook.Path command ? | Excel Programming | |||
Remove ThisWorkbook code via VBA | Excel Programming | |||
Help with ThisWorkbook | Excel Programming |