Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Adelisa Fischer   on Jan 27 In MS Office Category.

  
Question Answered By: Catherine Campbell   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.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

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


Tagged: