C
curlydave
I don't know why but this macro wants to exit excel when I run it
Sub resetpage()
Range("A3:S20").Select
Selection.ClearContents
Range("A3").Select
userform1.Hide
End Sub
I have userform1.hide because I have a worksheetchange event that goes
like this:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If Target.Column = 1 Then
userform1.Show False
myRow = Target.Row
End If
End Sub
When I run Sub resetpage()
it clears the contents and then asks if I want to save changes as if I
had clicked exit
Why is this now happening? it doesn't happen all the time ,but it
happens alot
Sub resetpage()
Range("A3:S20").Select
Selection.ClearContents
Range("A3").Select
userform1.Hide
End Sub
I have userform1.hide because I have a worksheetchange event that goes
like this:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If Target.Column = 1 Then
userform1.Show False
myRow = Target.Row
End If
End Sub
When I run Sub resetpage()
it clears the contents and then asks if I want to save changes as if I
had clicked exit
Why is this now happening? it doesn't happen all the time ,but it
happens alot