Excel Date

[All In]

I need to have the date in my excel spreedsheet change only when the sheets are updated. I have 4 or more sheets per workbook and not all sheets are not updated at the same time.

[SandyUK]

In the simplest terms this would do the trick and a good starting point

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Cells(1, 1) = Now

End Sub

Regards

Adrian

[Tom Ogilvy]

Use the change event

See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"All In" wrote:

>
> I need to have the date in my excel spreedsheet change only when the
> sheets are updated. I have 4 or more sheets per workbook and not all
> sheets are not updated at the same time.
>
>
> --
> All In
> ------------------------------------------------------------------------
> All In's Profile: http://www.excelforum.com/member.php...o&userid=36285
> View this thread: http://www.excelforum.com/showthread...hreadid=560658
>
>

[All In]

Thanks for the help. That seem to work for the whole spreed sheet. One more question is there a way to setit up differnt on the 4 sheets. The problem I have is that all the sheets in the workbook are not up dated at one time and I need to have the date show when there were update. Thanks again for the help.