Sorry. I'm not sure I understrand where to put the code.could you explain
again?
don

"Don Guillett" wrote:

If you put it in this one instead it will fire every time you change cells
in the active sheet.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
Sheets.Select
ActiveCell.EntireRow.Select
ActiveSheet.Select
End Sub


--
Don Guillett
SalesAid Software

"saranat" wrote in message
...
I have 7 worksheets in a workbook.
all the worksheets have a lastname, firstname, employee ID in the A,B,C
columns of every worksheet.
I need to synchronize the worksheets so that when I click on an employee
name in any worksheet and select a different worksheet I see the same row
as
the original employee name.