Can I group worksheets without updating all cells

Buckeye

New Member
Joined
Aug 25, 2002
Messages
1
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.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

white6174

Board Regular
Joined
May 6, 2002
Messages
137
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
 
Upvote 0

Forum statistics

Threads
1,191,578
Messages
5,987,403
Members
440,096
Latest member
yanaungmyint

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top