MrExcel Publishing
Your One Stop for Excel Tips & Solutions

navigation buttons


Posted by matthew on June 08, 2001 8:23 PM

how do you make navigation buttons on Excel spreadsheets. please help


Posted by Joe Was on June 08, 2001 9:05 PM

Tools - Marcros - Macro
Name your macro.
Create

On the code sheet:

Sub your macro name()

'This will go to the top of sheet1
'To go to the bottom change the Range("X") to a
'cell you want to go to. If you only want it
'to work on the active sheet, you can remove
'the sheet line!

Sheets("Sheet1").Select
Range("A1").Select
End Sub

On the macro menu, Option lets you assign a hot key to the VB Macro. Like CTRL-t for Top.

To make a button;
View - Forms

Select The button and place and size on your sheet where you want it. Select your macro name from the list, Edit the macro Button face lable and your done. (Click on the default button lable and delete & re-type.)

Hope this is what you wanted? JSW

Posted by steve w on June 09, 2001 9:44 AM


Hi matthew try this code.
The other code that joe Was helped you with selects the sheet then the cell, it runs slower and I found that didn't work how I wanted it to.I then recieved help on this site to get the following code.
steve w

Private Sub CommandButton1_Click()
Application.Goto _
Reference:=Sheet4.Range("A71"), Scroll:=True

End Sub