How to create navigation buttons

[freddo85]

Hello,

I'd like to create 'buttons' to navigate around my spreadsheet. I can create a button, but have no idea what code to put in it such that when I click on the button I am taken to a designated worksheet.

Thanks in advance for your help. Really appreciate it.

[raypayette]

Place your buttons right click one and assign one of these macros for example:
Sub Macro1()
ActiveCell.SpecialCells(xlLastCell).Select
End Sub
Sub Macro2()
ActiveCell.SpecialCells(xlCellTypeLastCell).Select
End Sub
Sub Macro3()
x = ActiveCell.Column
r = ActiveSheet.UsedRange.Rows.Count
Cells(r, x).Select
End Sub
Sub Macro4()
x = ActiveCell.Row
c = ActiveSheet.UsedRange.Columns.Count
Cells(x, c).Select
End Sub