functions

L

ludite

I have spreadsheets that I must keep track of when they were last edited. I
don't want the date it was opened =NOW() or =TODAY(), only if the spreadsheet
is changed. Is it possible to have that entered in a cell?
 
D

Don Guillett

If you want an update each time ANY change is made copy paste this to the
macro module of the ThisWorkbook. Be aware that this will fire EACH time any
change is made.


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.EnableEvents = False
Sheets("sheet1").Range("c4") = Date
Application.EnableEvents = True

End Sub
 
L

ludite

Don
Thank you for your help. I have created the macro as you outlined below but
perhaps I need to clarify my understanding of "an update each time ANY change
is made ". I would like to be able to enter the date a spreadsheet is
updated in a cell on the sheet. Is there a function that does this?
 
L

ludite

Don
The macro to insert updated date in spreadsheets is working very well.
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Need Help with Macro Security 1
Excel does not accept text format! 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Countdown macro - display settings 2
Difficulty with compatibility mode and Track Changes 2
Dealing with a Pivot Table (when I don't want to) 0
Having a 'not applicable' with a 0 ranking on a rating question 0

Top