Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Cancel = True
ActiveCell.Value = ActiveCell.Offset(-1, 0)
End Sub
Why will the above code not work when I protect a worksheet? The cells i want to be able to doubleclick and copy above information are not locked?
Is there a workaround?
Thanks
Cancel = True
ActiveCell.Value = ActiveCell.Offset(-1, 0)
End Sub
Why will the above code not work when I protect a worksheet? The cells i want to be able to doubleclick and copy above information are not locked?
Is there a workaround?
Thanks