Time and date stamp on a worksheet

[christal]

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!

[Tom Schreiner]

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

[christal]

Thanks Buddy!

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

[Tom Schreiner]

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

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

[christal]

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!!

[Brian from Maui]

chistal,

This is not automatic but using

Ctrl + ; enters the date only into a cell

[Tom Schreiner]

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

[christal]

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!

[lantiger]

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

[christal]

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

Thanks!