Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Quakers Hill, NSW, Australia
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Home Function (OfficeXP)

    I have a workbook with 25 sheets. I have created a sheet index with ASAP Utilities. Is there a way I can make a cell to act as a "home" button so that when clicked, it jumps to the sheet index page?

    Any ideas will be greatly appreciated.

    Thanks
    Neville

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Home Function (OfficeXP)

    Insert a hyperlink. Choose "Bookmarks" and select the sheet (and cell!) you want it to go to. Copy this hyperlink cell to all sheets you need it in.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Quakers Hill, NSW, Australia
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Home Function (OfficeXP)

    Thanks Jan, it was easy when I had some guidance to find it in the maze of features.

    Neville

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Home Function (OfficeXP)

    Sorry, I should have added where to look for it.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Quakers Hill, NSW, Australia
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Home Function (OfficeXP)

    Sorry Jan, I didn't phrase my reply correctly.
    I had searched proir to posting the question but as I was looking for a "home" function I didn't find a solution. After your help with "bookmarks" the rest was easy.
    Thanks again.
    Neville

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •