I have the follow code in the worksheet code to run a popup calendar.
I have another macro that clears the range of cells,
but i keep getting the below code running that prevents me clearing the range of cell contents.

How can i at the start of another macro, stop the below from running, yet still be
able to have the below to run if the cell is selected in the range NOT by the macro?


________________________________________________

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim MyRange As Range
If Not Intersect(Target, Range("C8:R30")) Is Nothing Then
Call frmCalendar.Show
'Call Macro7
'Call Ids
'Call Names_Print
'Call Names_Frequency
'Call SentenceCase
'Call Dates
'Call Shades
End If
End Sub

_______________________________________________

Corey....