Posts by heismanasu

    I have this code, and want to restrict it two 2 named ranges instead of the entire worksheet. What is best way to do this. Not very familiar with VBA.

    1. Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
    2. ActiveCell.Value = Now()
    3. Application.SendKeys "^{return}"
    4. Target = Format(Time, "h:mm:ss")
    5. Cancel = True

    End Sub