Prevent Text Box from being copied to a new sheet .

I suspect that what Kidd_lp intended was to use the SheetActivate event, so you don't have to wait for a cell to be changed:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    Dim txtBox As Shape
    If Sh.Name <> "Tab 7" Then '...or whatever the name of the template worksheet is
        For Each txtBox In Sh.Shapes
            If txtBox.Name = "TextBox1" Then    '...or whatever the nmae of the control is
                txtBox.Delete
            End If
        Next txtBox
    End If
End Sub

Not much more information is available in Microsoft documentation.

But I would be very concerned about sharing a macro-enabled workbook among employees.  Discuss the security concerns with your IT staff.