/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 vote111 views1 answer
Excel protect cells with formulas
VBA
4 votes123 views1 answer
Vba create directory
VBA
0 vote132 views1 answer
Vbnet find highest value in chart
VBA
0 vote148 views1 answer
Search for text in every worksheet excel visual basic
VBA
4 votes135 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
3 votes122 views1 answer
Extract the nth word from a text string
VBA
0 vote120 views1 answer
Excel vba scroll to cell
VBA
1 vote141 views1 answer
Vba optional
VBA
8 votes204 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote126 views1 answer
Vbnet check if string is only symbols
VBA