Same Location In ALL Worksheets

Hello,

Is there some trick or otherwise, so that when moving from worksheet to worksheet,
the page (screen) and the cursor (highlighted cell) is positioned the same in every worksheet?

I have workbooks that have multiple worksheets that are formatted/coded identically, but each has different data.

When I jump from worksheet to worksheet, looking for data in the same cell, I find it very cumbersome to then have to
scroll left/right/up/down to get to the cell of interest.

Thanks mehmetcik

I copy/pasted your code in ThisWorkbook module, and it is not working.
I do see what the code is supposed to be doing however.
Perhaps I have done something wrong.

As a test I added a MsgBox in the Workbook_Open sub, and it displays when the Workbook opens.

Another way using event handlers. I'll assume you don't need a Workbook_Open event handler and are content to open workbooks in the location they were last saved.

The following should be in ThisWorkbook.

Please Login or Register  to view this content.

The problem with Workbook_SheetDeactivate is that which Sh may refer to the worksheet the user just left, you need to save window properties from that worksheet to apply to the newly activated worksheet, and that requires going back to Sh in ActiveWindow, storing its top-left cell's and ActiveCell's addresses, the returning to the selected sheets and ActiveSheet.

Thanks to both!

Both solutions give me what I want.