Hello folks
I recently started dabbling with Command Buttons, and I'm having a problem. Everything used to work perfectly, so I don't know what changed. I use Excel 2013
I have 2 Command Buttons on this sheet. One of them works perfectly, and the second will only work once. Once I tell button 2 to do it's thing, the button then becomes unresponsive until I enter design mode and move the button. After moving the button, it will work once more, and then stop working again. The distance of the move doesn't appear to matter.
Here is the macro assigned to the problematic button. Would someone please tell me what's going on?
Private Sub CommandButton2_Click()
'
' Macro1 Macro
' Go Time
'
'
'
Range("A3").Select
Selection.AutoFilter
Range("Q3").Select
ActiveSheet.Range("$A$1:$AG$2438").AutoFilter Field:=12, Criteria1:="<>"
ActiveSheet.Range("$A$1:$AG$2438").AutoFilter Field:=1, Criteria1:="<>"
ActiveWindow.SmallScroll Down:=-24
End Sub
Bookmarks