+ Reply to Thread
Results 1 to 7 of 7

Bookmarks on Sheet

  1. #1
    Registered User
    Join Date
    07-24-2006
    Posts
    57

    Bookmarks on Sheet

    I have a sheet which is quite long. I need to create links, or a drop-down menu of some sort, which can select different points in the same sheet. So, if i click "Bookmark 4", it will scroll/direct the page to a certain point in the sheet.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099

    Thumbs up

    Quote Originally Posted by aposatsk
    I have a sheet which is quite long. I need to create links, or a drop-down menu of some sort, which can select different points in the same sheet. So, if i click "Bookmark 4", it will scroll/direct the page to a certain point in the sheet.
    Hi aposatsk,

    Try View > Custom Views, then select your range of cells and give then a meaningful name for your view

    oldchippy

  3. #3
    Registered User
    Join Date
    07-24-2006
    Posts
    57
    Okay. That is a step closer. But can i make the "Views" in Custom Views show up costantly on some toolbar or in a cell?

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099

    Thumbs up

    Quote Originally Posted by aposatsk
    Okay. That is a step closer. But can i make the "Views" in Custom Views show up costantly on some toolbar or in a cell?
    Record a macro in this workbook to select your named view, then create a new Toolbar and attach the macro to the custom button

    oldchippy

  5. #5
    Registered User
    Join Date
    07-24-2006
    Posts
    57
    thanks again!

    Can i run a macro using a formula? For example, in A2 i would write a formula such that when A1 is equal to 1, the macro is run.

  6. #6
    CLR
    Guest

    RE: Bookmarks on Sheet

    I would suggest you Freexe the top 8 or 9 rows and in that area put
    hyperlinks to wherever on the sheet you wish to go.......I always put TOP and
    BOTTOM arrows and assign appropriate macros on my databases to facilitate
    navigation.

    hth
    Vaya con Dios,
    Chuck, CABGx3



    "aposatsk" wrote:

    >
    > I have a sheet which is quite long. I need to create links, or a
    > drop-down menu of some sort, which can select different points in the
    > same sheet. So, if i click "Bookmark 4", it will scroll/direct the page
    > to a certain point in the sheet.
    >
    >
    > --
    > aposatsk
    > ------------------------------------------------------------------------
    > aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
    > View this thread: http://www.excelforum.com/showthread...hreadid=573799
    >
    >


  7. #7
    Dave F
    Guest

    Re: Bookmarks on Sheet

    You can run a macro via a udf.
    Info on creating UDFs here:
    http://www.vertex42.com/ExcelArticle...functions.html

    Essentially, record a macro, make note of its name, and assign a UDF to it,
    say runmacro. So, =runmacro() would, well, run that macro.

    --
    Brevity is the soul of wit.


    "aposatsk" wrote:

    >
    > thanks again!
    >
    > Can i run a macro using a formula? For example, in A2 i would write a
    > formula such that when A1 is equal to 1, the macro is run.
    >
    >
    > --
    > aposatsk
    > ------------------------------------------------------------------------
    > aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
    > View this thread: http://www.excelforum.com/showthread...hreadid=573799
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1