•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
Tagged with
#no-code spreadsheet solutions
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#macros
#automatically
#run
#Worksheet_SelectionChange
#updateDate
#prompt
#Excel
#code
#testdate
#Range
#Selection
#Target
#Intersect
#Value
#Exit Sub