Can I group worksheets without updating all cells

[Buckeye]

I'd like to toggle between multiple worksheets and always be on the same cell. I want to update the cell on the active spreadsheet without updating the same cell in the other spreadsheets. Is there a way to do this?

Without this feature, when I toggle between sheets I get the last activated cell in the 2nd sheet include of the current active cell in the 1st sheet.

 

[white6174]

try this,
paste this code in all worksheet modules

it stores the last activecells address of any sheet in cell A1 on Sheet1

this is all I could come up with(not sure if this is what you wanted)

steve w

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheet1.Range("A1") = ActiveCell.Address
End Sub

Private Sub Worksheet_Activate()
Application.ScreenUpdating = False
a = Sheet1.Range("A1").Value
Range(a).Select
Application.ScreenUpdating = True
End Sub
This message was edited by white6174 on 2002-08-26 20:50