Buttons

[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??

 

[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

 

[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.