Use the sheet activate event. Right click on the sheet tab, select view code
and then paste this event code onto the code sheet.

Private Sub Worksheet_Activate()
Cells.SpecialCells(xlCellTypeLastCell).Select
End Sub

Hope this helps
Rowan

"Daniel" wrote:

how do i make it so that when a sheat is selected either via link or tab,
that xlLastCell is selected. the last on the sheet.