Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time stamp revisions (not just when open/print file)
Is there a way to time stamp when a change/revision has been made to an excel
worksheet? For example, I have a weekly input of data...I want to know what day that input was made last...so that if someone turns in the worksheet and a change was made on Tuesday (and it's Friday)...I'll know that anything after Tuesday is not entered. -- Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time stamp revisions (not just when open/print file)
Hi,
You could use the Before save workbook event Alt+F11 to open VB editor. Double click 'This Workbook' and paste this in on the right. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) lastrow = Sheets("Sheet3").Cells(Cells.Rows.Count, "A").End(xlUp).Row Range("A" & lastrow + 1).Value = Now End Sub "Cando :o)" wrote: Is there a way to time stamp when a change/revision has been made to an excel worksheet? For example, I have a weekly input of data...I want to know what day that input was made last...so that if someone turns in the worksheet and a change was made on Tuesday (and it's Friday)...I'll know that anything after Tuesday is not entered. -- Thank you! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time stamp revisions (not just when open/print file)
Hi,
If you want to keep track of revisions, you will need to either create a VBA routine to do it (probably a lot of work) or turn on Shared Workbooks with Track changes. The are a fair number of downsides to shared workbooks, but take a look at the topic area in the help system and see if it meets your needs. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Cando :o)" wrote: Is there a way to time stamp when a change/revision has been made to an excel worksheet? For example, I have a weekly input of data...I want to know what day that input was made last...so that if someone turns in the worksheet and a change was made on Tuesday (and it's Friday)...I'll know that anything after Tuesday is not entered. -- Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When i open excel file it takes time to open | Excel Discussion (Misc queries) | |||
Open a print output sent to file | Excel Discussion (Misc queries) | |||
Can Excel open a new application every time you open a file? | Setting up and Configuration of Excel | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Desktop shortcut to a named Excel file - every time I open it adds a "1" to the file name - how to disable? | Setting up and Configuration of Excel |