Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code that removes some lines from "ThisWorkbook". This
seems to work fine from Excel 2000 and Excel 2002. However, it does not seem to work from Excel 2003. Is there any reason why this wouldn't work on Excell 2003 or later? Set CodeMod = ThisWorkbook.VBProject.VBComponents("ThisWorkbook" ).CodeModule With CodeMod StartLine = .ProcStartLine("Workbook_Open", vbext_pk_Proc) ProcLen = .ProcCountLines("Workbook_Open", vbext_pk_Proc) .DeleteLines StartLine, ProcLen End With Thanks in advance, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XL2003 - ThisWorkbook.VBProject.VBComponents("ThisWorkbook").CodeM | Excel Programming | |||
ThisWorkbook.VBProject.References | Excel Programming | |||
How to use VBA to copy this code to "thisworkbook" objects of all opened workbooks ? | Excel Programming | |||
?thisworkbook.VBComponents(5).Type returns 2 | Excel Programming |