View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RJD RJD is offline
external usenet poster
 
Posts: 6
Default Update date & time in a cell only when worksheet is changed

I have a workbook with multiple worksheets. I'd like to have the time & date
in a cell in each worksheet update only when information in that worksheet is
changed. I don't change each worksheet each time I use the workbook. I tried
=NOW(), but it changes the time and date in each worksheet.