Thread: Date stamp in worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
The Code Cage Team[_79_] The Code Cage Team[_79_] is offline
external usenet poster
  
Posts: 1
Default Date stamp in worksheets

This will date stamp the active sheet in A1 when a change is made:

Enter this in the ThisWorkbook module:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
Range("A1").Value = Now()
End Sub

Change Now() for DATE if you do not want the time


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=23440

Reply With QuoteReply With Quote