Home |
Search |
Today's Posts |
#1
|
|||
|
|||
macro help
i have a row of cells that total other cells...i want to
initiate a macro if any cell in this row changes. any ideas? thanks for your help. |
#2
|
|||
|
|||
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit: Application.EnableEvents = False If target.row= 1 Then With Target 'do your stuff End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "johnT" wrote in message ... i have a row of cells that total other cells...i want to initiate a macro if any cell in this row changes. any ideas? thanks for your help. |
#3
|
|||
|
|||
cant get it to work, shouldnt this be calculation event?
-----Original Message----- Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If target.row= 1 Then With Target 'do your stuff End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "johnT" wrote in message ... i have a row of cells that total other cells...i want to initiate a macro if any cell in this row changes. any ideas? thanks for your help. . |
#4
|
|||
|
|||
should clarify, using excel 97
-----Original Message----- cant get it to work, shouldnt this be calculation event? -----Original Message----- Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If target.row= 1 Then With Target 'do your stuff End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "johnT" wrote in message ... i have a row of cells that total other cells...i want to initiate a macro if any cell in this row changes. any ideas? thanks for your help. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Can't get simple macro to run | Excel Worksheet Functions | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro for multiple charts | Excel Worksheet Functions |