Time and date stamp on a worksheet

christal

New Member
Joined
Apr 7, 2002
Messages
45
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!
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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
 
Upvote 0
Your welcome Pal!
Activate means
When the sheet is actually selected, viewed.
This message was edited by TsTom on 2002-04-10 10:11
 
Upvote 0
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!!
 
Upvote 0
Have you tried the "tools","Track changes", thingy?
I think it highlights changes made???
I've never used it...
Tom
 
Upvote 0
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!
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top