/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 vote123 views1 answer
Get current year vb
VBA
0 vote131 views1 answer
Vbnet hex to binary
VBA
0 vote130 views1 answer
Vba code to open a file with login rights
VBA
0 vote133 views1 answer
Nested if else in vb.net
VBA
0 vote134 views1 answer
Putting marquee in vb.net
VBA
0 vote116 views1 answer
Vbnet display all axis labels in cahrt
VBA
3 votes141 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote130 views1 answer
Make your computer talk vbscript
VBA
0 vote138 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote136 views1 answer
Excel vba delete folder
VBA