Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel Link

  Asked By: Adelisa    Date: Jan 27    Category: MS Office    Views: 737
  

I want to create a button on active excel sheet, which link to another
spread sheet when click.
Could anyone kindly tell me how to link the button to another sheet?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Catherine Campbell     Answered On: Jan 27

If all you want to do is jump to another place in the same
spreadsheet, the quickes way is to hyperlink. Slap in some clip art
or draw a box w/your drawing tools. Right click  and down near the
bottom of the list is 'Hyperlink'. When that box comes up you have a
few choices on the left hand side. One if them is 'Place in this
Document'. Click on that button  and you can jump to specific cells in
specific sheets ('Project Data'!A1) via the address box at the top or
a named range (I love named ranges).

If you're opening up another workbook, you'll have to write a little
code.

Sub Open()

ChDir "C:\Documents and Settings\Desktop"
Workbooks.Open Filename:= _
"C:\Documents and Settings\Desktop\Accounting.xls"
Range("B2").Select
End Sub


Same button idea (clip art, drawing tools, etc.) Right click on your
clip art or drawn button and select 'Assign Macro', scroll through
the list, select it and hit OK.

 
Answer #2    Answered By: Janet Phillips     Answered On: Jan 27

Now I can link  to another spread sheet  by
drawing a text box. But one more question, is it possible to modify
the 2-D text box to be a 3-D button, like the button  created by
control box?

 
Didn't find what you were looking for? Find more on Excel Link Or get search suggestion and latest updates.




Tagged: