Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete macro with code
how do you delete a macro with code.
i have a file(OpenWO) with code to high like row when you click on them or arrow down/up. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlColorIndexNone Target.EntireRow.Interior.ColorIndex = 36 End Sub but at the end of each month, i run another macro that colors up the data with 9 different colors depending of conditions then save the file off with a different name as a monthly record. i have to delete the above macro before runing the EOM macro or risk distroying all of the other colors. I would like to delete the above macro with code when i run the EOM macro. any one know how to do this?? thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete macro with code
See www.cpearson.com/excel/vbe.htm for details and example code.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "FSt1" wrote in message ... how do you delete a macro with code. i have a file(OpenWO) with code to high like row when you click on them or arrow down/up. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlColorIndexNone Target.EntireRow.Interior.ColorIndex = 36 End Sub but at the end of each month, i run another macro that colors up the data with 9 different colors depending of conditions then save the file off with a different name as a monthly record. i have to delete the above macro before runing the EOM macro or risk distroying all of the other colors. I would like to delete the above macro with code when i run the EOM macro. any one know how to do this?? thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete macro with code
thanks chip. works great in test. now to add it to my EOM
macro. this will really keep my butt out of future hot water. -----Original Message----- See www.cpearson.com/excel/vbe.htm for details and example code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "FSt1" wrote in message ... how do you delete a macro with code. i have a file(OpenWO) with code to high like row when you click on them or arrow down/up. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlColorIndexNone Target.EntireRow.Interior.ColorIndex = 36 End Sub but at the end of each month, i run another macro that colors up the data with 9 different colors depending of conditions then save the file off with a different name as a monthly record. i have to delete the above macro before runing the EOM macro or risk distroying all of the other colors. I would like to delete the above macro with code when i run the EOM macro. any one know how to do this?? thanks in advance. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code to delete module / macro in another file | Excel Discussion (Misc queries) | |||
Macro code to delete conditional formatting | Excel Discussion (Misc queries) | |||
make macro change (delete) its own code | Excel Programming | |||
Delete VBA code in worksheet through a macro | Excel Programming | |||
Delete VBA code in worksheet through a macro | Excel Programming |