Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As an aside, I'm getting so much better at modifying code that I get
from the ng archives now. Long time coming since I'm just not a natural at all this stuff <g! I was able to modify the code below and it works great except when I protect the worksheet. -------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Then Exit Sub On Error GoTo ErrHandler If Target.Column = 3 Then ' COLUMN 3=COLUMN C Application.EnableEvents = False If Not IsEmpty(Target) Then Cells(Target.Row, 2).Value = Now ' COLUMN THAT HAS DATE ADDED TO IT ' Cells(Target.Row, 1).NumberFormat = 'yyyy.mm.dd.ddd., hh"h"mm' Else Cells(Target.Row, 2).ClearContents ' COLUMN THAT HAS DATE ADDED TO IT, make sure it's the same as above. End If End If ErrHandler: Application.EnableEvents = True End Sub -------------------------------- Is there any way to get have it work without leaving the sheet unprotected? Thx! :oD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need a work around for a protected worksheet | Setting up and Configuration of Excel | |||
AutoFilter can't work after the worksheet is being protected!!! | Excel Programming | |||
How to make TAB key work in a protected worksheet | Excel Programming | |||
Can't Get Objects To Work In A Protected Worksheet | Excel Worksheet Functions | |||
Why doesn't spell check work on a protected worksheet? | Excel Worksheet Functions |