Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
programming VBE - Deleting All Code From A Module
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
regular code module | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
Change case...help please | Excel Worksheet Functions | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |