/VBA/Excel vba Run a Macro every time sheet is changed

Excel vba Run a Macro every time sheet is changed

'In the VBA code module for that particular worksheet, add this:

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    
    'The name of your Macro or subroutine goes here <--
    
    Application.EnableEvents = True
End Sub

Source: stackoverflow.com

Similar codes

0 vote379 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote384 views1 answer
Vba foreach 2d array
VBA
0 vote334 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote284 views1 answer
Excel vba linter
VBA
0 vote358 views1 answer
Excel vba protect shapes
VBA
0 vote317 views1 answer
Excel vba disable mouse click
VBA
0 vote329 views1 answer
Vba change named range address
VBA
0 vote355 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote341 views1 answer
Excel protect cells with formulas
VBA
0 vote324 views1 answer
Get current url vb.net
VBA