Hi Tom, If you mean a button for each link that would run you out of memory VERY fast. See my page on Slow Response http://www.mvps.org/dmcritchie/excel/slowresp.htm You can use a doubleclick event to goto the sheet named in a cell. For more information and how to install a worksheet events see http://www.mvps.org/dmcritchie/excel/event.htm Worksheet Events are installed with the worksheet by right-clicking on the sheettab, choose 'view code', and then paste in your macro. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True 'Get out of edit mode gotosheet End Sub In combination with the following normal macro, that you can assign to a toolbar button or in this case within the event macro above. Sub GoToSheet() 'David McRitchie www.mvps.org/dmcritchie/excel/buildtoc.htm Dim WantedSheet As String WantedSheet = Trim(ActiveCell.Value) If WantedSheet = "" Then Exit Sub On Error Resume Next If Sheets(ActiveCell.Value) Is Nothing Then MsgBox "Worksheet " & WantedSheet & " was not found, use RClick on " _ & "Sheet Tab Navigation arrow in lower left corner " _ & "to find desired sheetname." Else Sheets(ActiveCell.Value).Select End If On Error GoTo 0 End Sub --- The use of HYPERLINK is a another possibility and involves no macros, but it can get rather messy. Something like: the workbook name will be in cell B2 B2: =MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1) or code the name of the workbook directly into cell B2 B2: 'Tom_WB.xls They HYPERLINK worksheet function requires the name of the workbook when referring to an Excel workbook. A20: IBM B20: =HYPERLINK("[" & $B$2 & "]'" & A21 & "'!A1", "x") equivalent to: =HYPERLINK("[Tom_WB.xls]'IBM'!A1","x") Placing it this way makes it easy to update rather than =HYPERLINK("[Tom_WB.xls]'IBM'!A1","IBM") You could make the second operand display a total found in cell D5 on the referred worksheet, but link to cell A1 B20: =HYPERLINK("["&$B$2&"]'"&A20&"'!A1",INDIRECT("'"&A20&"'!D5")) Looks kind of complicated but use of the fill-handle makes the application of these formulas simple. ------ HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Macros: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "news.is.co.za" wrote in message news:3c345f16$0$227@hades.is.co.za... > Hi all ! > > I have a spreadsheet containing a list of 600 company names and I would like > to create buttons next to each name which, when clicked, will move the > spreadsheet user directly to another sheet which I will fill with details > about that company. > > Could anyone tell me how to create these buttons? > > Thanks for the help. > > Tom ----------------- Hi Matt, microsoft.public.excel, 2004-03-06 I have a some pages pages on HYPERLINKS http://www.mvps.org/dmcritchie/excel/sheets.htm http://www.mvps.org/dmcritchie/excel/buildtoc.htm http://www.mvps.org/dmcritchie/excel/buildtoc2.htm Not sure what you are asking, a hyperlink only transfers you to another cell it does not change values anywhere. You can reference another cell to obtain the value of another cell.just like you use =Sheet1!G3 You can use an object hyperlink to refer to another cell On your sheet enter your =Sheet1!G3 What you see when you enter an object hyperlink will vary slightly depending on your version of Excel, I have Excel 2000. Right click on cell, choose Hyperlink Edit Hyperlink type the cell reference: A1 place in this document: select sheet i.e. Sheet1 You can use a HYPERLINK Worksheet Formula (which I prefer) to refer the cell content in Sheet1!G3 and link to cell Sheet1!A3 =HYPERLINK("sheet1!A3",Sheet1!G3) but note the double quotes, if you change the location by inserting/ deleting rows/columns what is in quotes remains unchanged. There is a solution to that, so that the address is not in quotes: =HYPERLINK("#"&cell("address",Sheet1!A3,Sheet1!G3) If you are using hyperlinks you can use the Forward (Alt+ArrowRt) and Back (Alt+ArrowLt) buttons just like in your browser, your can install these buttons on your Excel toolbar: Tools, Customize, Commands (tab), Web, then drag the buttons on the right side you want add to where you want them on your toolbar. -- For those with Excel XL (Excel 2002) you can suppress hyperlink generation under the Auto Correct from the Tools menu, or turn them back on. To regerate hyperlinks after having them turned off, use F2 then Enter to fix individually or to a selection with a macro see MakeHyperlinks macro at http://www.mvps.org/dmcritchie/excel/buildtoc.htm ------------- If you use a link or if you use hyperlinkaddress you can use the web BACK key (Alt+ArrowLeft) to return. You can install the buttons on your toolbar from tools, customize, commands, Web, and drag the two buttons back and forward to the toolbar. If your button is on the worksheet you can hyperlink to you help worksheet. I don't think you can do that you can assign a hyperlink directly to a toolbar button without having it invoke a macro instead. as a hyperlink on the worksheet =HYPERLINK("[workboo14.xls]helpme!a5","help") =HYPERLINK("#helpme!E6","help") =HYPERLINK("#"Help Me'!A1","help") As a DoubleClick Event macro Private Sub Worksheet_BeforeDoubleClick(ByVal _ Target As Range, Cancel As Boolean) Cancel = True 'Get out of edit mode Dim xx As String xx = "#helpme!E6" ActiveWorkbook.FollowHyperlink Address:=xx, NewWindow:=False End Sub As mentioned at the beginning you can return with the Keyboard Shortcut ALT+ArrowLeft or with the Toolbar BACK button > Here is my problem, i have a worksheet, and that worksheet has a macro > connected to a button pointing to another sheet labled "helpfile" > > what i want to happen is when someone is on the helpfile sheet they can > press a button named "return to last sheet" or something, when they > press it it takes them to the sheet they selected the helpfile from > > for example the user path would be like this > > user is on sheet, january 2004 > > Hit button labled "helpfile" ---------------------------------