SamT
01-26-2017, 01:27 PM
As soon as either Worksheet sub Ends, I get a "This Action Will Reset Your Project" Warning.
Any ideas why. Using Excel XP in Windows XP.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Target.Address = "$D$1" Then Exit Sub
If Target = "" Then Exit Sub
Cancel = True
frmDater.Show
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Target.Address = "$D$1" Then Exit Sub
If Not Target = "" Then Exit Sub
frmDater.Show
End Sub
Also see Excel custom data validation with drop down list (http://www.vbaexpress.com/forum/showthread.php?58385-Excel-custom-data-validation-with-drop-down-list)
Any ideas why. Using Excel XP in Windows XP.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Target.Address = "$D$1" Then Exit Sub
If Target = "" Then Exit Sub
Cancel = True
frmDater.Show
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Target.Address = "$D$1" Then Exit Sub
If Not Target = "" Then Exit Sub
frmDater.Show
End Sub
Also see Excel custom data validation with drop down list (http://www.vbaexpress.com/forum/showthread.php?58385-Excel-custom-data-validation-with-drop-down-list)