| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Stamping A Cell | Excel Discussion (Misc queries) | |||
| Elapsed time when separate cells contain time and separate date | New Users to Excel | |||
| Running averages and time stamping | Excel Worksheet Functions | |||
| Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
| How to chnge 35 relative cells to 35 absolute cells at one time. | Excel Worksheet Functions | |||
Linear Mode
