Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]()
hello,
i have a file remove.xls in which i use such a code: Sub DeleteAllCodeInModule() Dim VBCodeMod As CodeModule Dim StartLine As Long Dim HowManyLines As Long Set VBCodeMod = Workbooks("new.xls").VBProject.VBComponents("Sheet s4").CodeModule With VBCodeMod StartLine = 1 HowManyLines = .CountOfLines .DeleteLines StartLine, HowManyLines End With End Sub to remove Private Sub Worksheet_Calculate() in new.xls than i save and close file, but on reopening new.xls an information about existing macros is appears and i do not know why? there is no VBA code in file. i checked carefully other sheets and ThisWorkbook and they are empty... does somebody has any idea what is going on? i use office xp.. regards peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
programming VBE - Deleting All Code From A Module | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Problem deleting vba module using vba code | Excel Programming | |||
Run worksheet module code from workbook module? | Excel Programming | |||
Deleting a module | Excel Programming |