TIMESTAMP - MULTIPLE TABS SAME SHEET

[DMCK]

Hi,
I have created timestamps for multiple tabs, but they all seem to override each other, which means only one tab timestamp works at any one time.

How do i get them to operate on different tabs without effecting each other?

Code i am using which works but not for multiple timestamps on multiple tabs seprately.

Private Sub Worksheet_Change(ByVal Target As Range)

Dim myTableRange As Range
Dim myDateTimeRange As Range
Dim myUpdatedRange As Range

Set myTableRange = Range("B6:F15")

If Intersect(Target, myTableRange) Is Nothing Then Exit Sub

Set myDateTimeRange = Range("G" & Target.Row)
Set myUpdatedRange = Range("G" & Target.Row)

If myDateTimeRange.Value = "" Then

myDateTimeRange.Value = Now

End If

myUpdatedRange.Value = Now


End Sub

 

[VBasic2008]

Does it matter what format I save it in for it to work?

You have to save it as .xlsm or .xlsb.