/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 vote361 views1 answer
Excel vba saveas no prompt for overwrite
VBA
15 votes493 views2 answers
Xl vba dynamic string array
VBA
0 vote347 views1 answer
Vbnet display all axis labels in cahrt
VBA
1 vote360 views1 answer
Vba reverse string
VBA
0 vote364 views1 answer
Vba type
VBA
0 vote353 views1 answer
Vbs write file
VBA
0 vote374 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote354 views1 answer
Vba paste values
VBA
0 vote370 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote360 views1 answer
Limit combobox to list vba
VBA