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.

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

    End Sub