Time and date stamp on a worksheet
Time and date stamp on a worksheet
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Time and date stamp on a worksheet

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Can anyone tell me if you can put an automatic time and date stamp on a WORKSHEET only (let's say in a cell on that worksheet). I can't tell weather a particular sheet has been updated, only the file... and then I have to go into properties to find out.

    Any ideas?

    Thanks
    Christal

    Thanks!

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This will tell you when the worksheet has been activated.
    I don't know how you could determine if it has been updated at a specific time, automatically?

    Private Sub Worksheet_Deactivate()
    Range("A1").Value = Now
    End Sub

    Tom

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Buddy!

    But not to be picky.... what does activate mean.... a saved workbook?

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Your welcome Pal!
    Activate means
    When the sheet is actually selected, viewed.

    [ This Message was edited by: TsTom on 2002-04-10 10:11 ]

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yea... I thought so.... That really doesn't help. I have got such a mess with these spreadsheets, and everyone has their hands on them! If you can think of a better way of managing these spreadsheets, while still allowing users to access them, I would be forever in your debt!!

    Thanks Again!!

  6. #6
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    chistal,

    This is not automatic but using

    Ctrl + ; enters the date only into a cell

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you tried the "tools","Track changes", thingy?
    I think it highlights changes made???
    I've never used it...
    Tom

  8. #8
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    O.K. Tom... making fun of my technical language (tools "thingy")!! Ha, Ha, Ha! (:o)

    Tracking changes... that's and idea... although it has a tendancy to really "junk-up" the spreadsheet. I'll try it!!

    Thanks again so much!!

    This site is great!

  9. #9
    New Member
    Join Date
    Apr 2002
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can also use the following to add timestamps.

    1. WorkbookBeforeSave 'Before user save the workbook duh
    2. WorkbookBeforeClose 'Before close
    3. SheetChange ' this could generate a lot of events, so unless you really needed, don't use this.

    for complete excel events, look the online help files

    HTH

    lantiger

  10. #10
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I'll try in and let you know if it works!!

    Thanks!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com