Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Change-event macro
Hi All....
I have a change-event macro on a sheet that calls another macro from another module.....this works fine Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$E$8" Then Call FormatCurrency Else End If End Sub Problem is, 1-When I make a copy of that sheet, to save as another workbook, the ChangeMacro goes with the new sheet and the new workbook does not have the 'FormatCurrency" macro. 2-I then run another macro to delete entire rows from well below row 8, and the ChangeMacro triggers and I get a "Compile error: Argument not optional"and the macro stops on the "Call FormatCurrency" line . It should not even trigger because I am not changing cell E8. Any help or thoughts would be apprecaited Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disable combo change event temporaraly | Excel Programming | |||
how to disable listbox change event | Excel Programming | |||
Enable/Disable Worksheet Change Event code | Excel Programming | |||
Disable Change Event in Form | Excel Programming | |||
Disable Worksheet change event | Excel Programming |