Buttons

  • Thread starter Thread starter Gary Thomson
  • Start date Start date
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??
 
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
 
Try
=HYPERLINK("[filename.xls]sheetname!Z500","go")
replacing 'filename' with the name of your file, and 'sheetname' with the
name of the sheet.
 
Back
Top