Buttons

G

Gary Thomson

Is there any way of putting a "button" sort of thing in
one of my sheets, so that if the user clicks on it, it
will take the user to cell reference Z500??
 
J

John

Make sure you have the 'Forms' toolbar visible.
Click on the fourth button along (grey rectangle) and on
the worksheet click and drag until you have the size you
want. A popup box appears, press new and between the
first and last line type

Application.Goto Reference:="R500C26"

That should do it!

John
 
S

Stephen Bye

Try
=HYPERLINK("[filename.xls]sheetname!Z500","go")
replacing 'filename' with the name of your file, and 'sheetname' with the
name of the sheet.
 
Top