•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Automatically run macros without prompt to run a macro
I have a code here but the code still prompting to run a macro.
I need to run the macro Automatically.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("H9:N13,P9:V13,X9:AD13")) Is Nothing Then Exit Sub Else Call updateDate End If End Sub Sub updateDate() Range("testdate").Value = Selection.Value End Sub [link] [comments]
Want to read more?
Check out the full article on the original site