/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 vote186 views1 answer
Vbscript Trim
VBA
25 votes318 views3 answers
String to date vb
VBA
1 vote165 views1 answer
Excel vba make cell visible
VBA
0 vote153 views1 answer
Excel protect cells with formulas
VBA
22 votes320 views1 answer
Xl vba check for folder
VBA
0 vote195 views1 answer
Create new worksheet excel visual basic
VBA
0 vote166 views1 answer
Excel vba send HTTP POST to server
VBA
1 vote186 views1 answer
Extract the second word in a text in excel
VBA
6 votes176 views1 answer
Excel vba check if a string only contains letters
VBA
1 vote172 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA