Thanks for trying but as i said i cannot change spreadsheet A in any way.

Does anyone else have any ideas?

Thanks




"All In" wrote:


Hi try this bit of code I got from another user. I think we are trying
to do the same thing. I setit up as a macro. Every time my boss opens
the spreed sheet and changes something it puts the date it was updated
on the sheet.


Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Cells(1, 1) = Now

End Sub




I hope this helps you

All In


--
All In
------------------------------------------------------------------------
All In's Profile: http://www.excelforum.com/member.php...o&userid=36285
View this thread: http://www.excelforum.com/showthread...hreadid=560635