You might get what you want by searching the Help - input 2Track changes in a
shared workbook"

I don't think yours is shared but it may help you.

Good luck

Cheers
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"jcheko" wrote:

your macro does work and it will put the date and time you included in the
quotation signs that is cool, but it won't recognize if I modified the
spreadsheet, all I am saying is that if between "range a5:s33" I changed
something on it, the date should update, do you have another suggestion?
thanks alot



"Russell Dawson" wrote:

There's probably a really good way to do this.

How about this macro. It uses the shortcuts for date Ctrl ; and for time
Ctrl/Shift ;
Activates by Ctrl S and includes a save. So, whenever you want to save the
changes enter Ctrl-S and the date and time will appear. Change cells to
suit. Format cells appropriately.

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+s
'
Range("A1").Select
ActiveCell.FormulaR1C1 = "4/9/2010"
Range("A2").Select
ActiveCell.FormulaR1C1 = "5:47:00 PM"
Range("A3").Select
ActiveWorkbook.Save
End Sub
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"jcheko" wrote:

I need to figure out a formula that returns the date when the spreadsheet was
last modified. any changes number, letter, symbol...if I make any change I
need the formula to return back the date teh spreadsheet was last
modified...any
help....thanks