Time Stamping Cells
 

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.

Time Stamping Cells
 

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

"Time" wrote:

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.

Time Stamping Cells
 

Like the event macro like the one that JE McGimpsey shares:
http://www.mcgimpsey.com/excel/timestamp.html

Seems like a good idea.

Time wrote:

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.

--

Dave Peterson

Time Stamping Cells
 

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?

"Dave Peterson" wrote:

Like the event macro like the one that JE McGimpsey shares:
http://www.mcgimpsey.com/excel/timestamp.html

Seems like a good idea.

Time wrote:

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.

--

Dave Peterson

Time Stamping Cells
 

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.

Time wrote:

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?

"Dave Peterson" wrote:

Like the event macro like the one that JE McGimpsey shares:
http://www.mcgimpsey.com/excel/timestamp.html

Seems like a good idea.

Time wrote:

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.

--

Dave Peterson


--

Dave Peterson

Time Stamping Cells
 

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.

"Dave Peterson" wrote:

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.

Time wrote:

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?

"Dave Peterson" wrote:

Like the event macro like the one that JE McGimpsey shares:
http://www.mcgimpsey.com/excel/timestamp.html

Seems like a good idea.

Time wrote:

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.

--

Dave Peterson


--

Dave Peterson

Time Stamping Cells
 

The security level setting doesn't travel with the workbook--it's a setting that
each user has to change.

Time wrote:

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.

"Dave Peterson" wrote:

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.

Time wrote:

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?

"Dave Peterson" wrote:

Like the event macro like the one that JE McGimpsey shares:
http://www.mcgimpsey.com/excel/timestamp.html

Seems like a good idea.

Time wrote:

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.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Time Stamping Cells
 

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

You cannot export these.


Gord Dibben MS Excel MVP

On Thu, 8 Mar 2007 11:47:02 -0800, Time wrote:

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.

"Dave Peterson" wrote:

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.

Time wrote:

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?

"Dave Peterson" wrote:

Like the event macro like the one that JE McGimpsey shares:
http://www.mcgimpsey.com/excel/timestamp.html

Seems like a good idea.

Time wrote:

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.

--

Dave Peterson


--

Dave Peterson