View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gerard Sanchez Gerard Sanchez is offline
external usenet poster
 
Posts: 46
Default Name Sheet Tab to Reflect Edit Date

'Hi,

'I got this simple code, I was wondering if anybody here can help me put
the 'value of "_timestamp" (see below) as name of my worksheet.


Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Names.Add Name:="_timestamp", RefersTo:=Now

End Sub