/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 vote139 views1 answer
Vba find sub dictionary
VBA
1 vote141 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote133 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote157 views1 answer
Vba multiple optional arguments
VBA
0 vote129 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote131 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote144 views1 answer
Check if program is running vbnet
VBA
1 vote142 views1 answer
Vbscript convert ascii code to character
VBA
0 vote132 views1 answer
Vba createparameter null
VBA
0 vote140 views1 answer
Excel vba saveas no prompt for overwrite
VBA