Time Stamping Cells

T

Time

So I was given this formula from this online help (very grateful by the way,
thanks for the help!!):

=IF(A1="","", IF(B1="", NOW(), B1))

But the thing is, it is a shared workbook. So when I hit save on my
computer, it does not reflect the time that "cell A1" was originally entered,
but rather the time it showed up "updated" on my computer. How can I prevent
this from happening? Would it be easier to put in the worksheet_change event
that I've been reading about on this site? Whichever is simpler will do.
Thanks for all the help everyone.
 
M

Mike

Right click the sheet tab and paste this code in.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
Target.Offset(, 1) = Time
End Sub

Any data entered into column A will be time stamped in Col B and the date
will not change.

Mike
 
T

Time

Is there a way that I can enable the macro without the popup box showing up
prompting if I would like to diable or enable macro?
 
D

Dave Peterson

You can change the security level to the lowest (MS doesn't recommend this) or
you could digitally sign the workbook and then trust that author.
 
T

Time

So I tried both methods. I changed the security level to LOW then saved. I
tried to open the shared workbook on another computer, and it still ask if i
want to enable/disable macro. I tried using the SELFCERT.EXE but i'm not all
too familiar with that.
 
D

Dave Peterson

The security level setting doesn't travel with the workbook--it's a setting that
each user has to change.
So I tried both methods. I changed the security level to LOW then saved. I
tried to open the shared workbook on another computer, and it still ask if i
want to enable/disable macro. I tried using the SELFCERT.EXE but i'm not all
too familiar with that.
Click to expand...
 
G

Gord Dibben

Selfcert certificates are good only on the computer on which they are created.

You cannot export these.


Gord Dibben MS Excel MVP

So I tried both methods. I changed the security level to LOW then saved. I
tried to open the shared workbook on another computer, and it still ask if i
want to enable/disable macro. I tried using the SELFCERT.EXE but i'm not all
too familiar with that.
Click to expand...
 
Top