Thread
:
HOW DO i SYNCHRONIZE MULTIPLE WORKSHEETS IN EXCEL?
View Single Post
#
3
Don Guillett
Posts: n/a
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.
Reply With Quote