Posts by heismanasu

  • Restrict VBA to Named Range

    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.


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







    End Sub