Thanks Max. When i tried the code it kept bringing me back to the same 1st
worksheet in which I highlighted the row.
saranat

"Don Guillett" wrote:

try this by right click on excel icon in upper left of workbook(next to
FILE)insert this.
However, it will not fire until you goto the next worksheet.

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Sheets.Select
ActiveCell.EntireRow.Select
ActiveSheet.Select

--
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.