RunTime err when using now()

[Licoule]

Hi there!
I'm trying to make an "Index" page that will update the time a sheet in the workbook was edited.
so far the code I put in each worksheet is

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Range("A1").Value = Now()
End Sub

Then I'm calling the Value of A1 in the Index sheet. I've been getting a run time error from the code, and the best I can figure is it's a logic loop.
When it updates the time it changes the page witch updates the time so on and so forth.
Any help ya'll could provide would be wonderful. I'm new to VBA and feel like I'm stumbling around in the dark.

 

[LockeGarmin]

You need to turn off Events in Excel before making a change to the worksheet. Otherwise your worksheet change makes a worksheet change which makes a worksheet change which makes a worksheet change.....

Private Sub Worksheet_Change(ByVal Target As Excel.Range)  

  Application.EnableEvents = False
  Range("A1").Value = Now()
  Application.EnableEvents = True
  
End Sub

 

[Licoule]

Thank you so much, That was a huge help. The bit of incite also helped to solve another problem to boot!