hello,
Long story and complicated workbook down to the issue at heart... I have a worksheet where those submitting work to me can simply open the file, place an X in a table with respect to what they have completed/submitted, and excel creates a TIMESTAMP() based on this code:
Public Function TIMESTAMP() As Date
TIMESTAMP = Now
End Function
I did this in order to overcome the automatically updating NOW() function. However, when you exit out of the file, and reenter, then Enable Macros, it just gives the current time instead of the time the X was originally placed.
Anyone have any ideas on how to overcome this. I was thinking maybe something to paste special value, but then it would still be referencing the cell that the date was placed which would change when opening the file. Can you paste special value only once and then NOT update it after that?
I believe one solution would be to make it a trusted location but that would be very difficult considering the company security and the fact that people will be accessing this document and amending it all over the world.
I'm in intern and was given an assignment of tracking and calculating statistics on late/early submissions for our profit centers worldwide. I would love to figure out how to solve this issue, could be something great toward a future job offering.
Thanks!!
Chase
Long story and complicated workbook down to the issue at heart... I have a worksheet where those submitting work to me can simply open the file, place an X in a table with respect to what they have completed/submitted, and excel creates a TIMESTAMP() based on this code:
Public Function TIMESTAMP() As Date
TIMESTAMP = Now
End Function
I did this in order to overcome the automatically updating NOW() function. However, when you exit out of the file, and reenter, then Enable Macros, it just gives the current time instead of the time the X was originally placed.
Anyone have any ideas on how to overcome this. I was thinking maybe something to paste special value, but then it would still be referencing the cell that the date was placed which would change when opening the file. Can you paste special value only once and then NOT update it after that?
I believe one solution would be to make it a trusted location but that would be very difficult considering the company security and the fact that people will be accessing this document and amending it all over the world.
I'm in intern and was given an assignment of tracking and calculating statistics on late/early submissions for our profit centers worldwide. I would love to figure out how to solve this issue, could be something great toward a future job offering.
Thanks!!
Chase