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.

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.

Think Don G. posted this instruction in his first response
try this by right click on excel icon in
upper left of workbook(next to
FILE) insert this

Maybe try these steps to get it up:
Right-click on the Excel icon in the upper left corner (Next to "File")
Choose "View Code" (this'll bring you to VBE)
Clear the defaults** appearing in the whitespace on the right
Then copy paste Don G's code in the whitespace
(You'd need to correct the line-wrap for the first line after you copy and
paste)
Press Alt+Q to get back to Excel
-----------------
**Defaults : "Private Sub Workbook_Open() ... End Sub"
-----------------
In Excel, try it out by selecting a cell say, A2 in Sheet1
The entire row2 will be selected (i.e. highlighted)
Click on Sheet2's tab, the same row2 will be selected
Ditto when you click on Sheet3, etc
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"don" wrote in message
...
Sorry. I'm not sure I understrand where to put the code.
could you explain again?
don