open worksheet with same cell in upper-left corner

[WayneTN]

Can I set up a worksheet so that, when it is opened, it will have the same cell in the upper left corner regardless of how the sheet was shifted prior to the last save?

[Mark W.]

Yes, with an Auto_Open macro.

[WayneTN]

Thanks, Mark. I'll try to get this set up and see how it works. I'd searched Help and this forum, but didn't really know what keywords to use so I didn't get very far.

[Russell Hauf]

Use the Workbook_Open event. Something like this:

Private Sub Workbook_Open()
Application.Goto Range("G20"), True
End Sub

- replace the Range("G20") with something denoting the cell you want to have in the upper-left. If you don't know how to get to the Workbook events, let us know.

Hope this helps,

Russell

[Mark W.]

Russell, I believe you'll need to go to another cell that's "off screen" before you go to the desired cell. Otherwise, you might not position the active cell in the upper-left corner of the window.

[Russell Hauf]

Correct as usual, Mark. So maybe put a line above the GoTo line - something like this:

Range("A65000").Select

[Lewis]

You could hyperlink to a named cell.

To name a cell click on the name box in top left hand corner of the worksheet enter the name click enter. this will then act as a bookmark so a hyperlink to workbook.xls#name opens workbook with the cell named name in top left hand corner.

Lewis