Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bespoke scrollbars in a worksheet (2003 sp2)

    Good morning

    On a particular worksheet I would like to hide the scrollbars (even I can do that!!) but I have a cell that is hyperlinked to a list much further down the WS and I wondered if I could add a 'bespoke' scroll bar so that the user can scroll up and down this list only and then use a hyperlink to go back to the top of the form. I have experimented with both of the toolbar scroll buttons and all I can do is get it linked to a cell that shows the different references as I scroll up and down but the scroll does not allow me to go below the bottom of the page as a normal scroll bar would do.

    I can't use a listbox because the list is a public holiday list which I want people to be able to delete entries from or add entries to. I can improvise by hyperlinking up and down the list but thought a scrollbar would look smarter.

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Bespoke scrollbars in a worksheet (2003 sp2)

    Have you thought about putting the list on a different sheet? It will be a lot easier than what you are trying to do!
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bespoke scrollbars in a worksheet (2003 sp2)

    Hi Rory

    It is a named range that is referenced over several sheets, past experience tells me if I muck about and move it to a different location everything will stop working, that is why I was trying to do something insitu. If your response, as I am sure it is, is the logical and practical way I shall make about 10 copies of the workbook, lock one away somewhere and try making the changes in my spare copies and see what happens <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bespoke scrollbars in a worksheet (2003 sp2)

    Have you looked at Data | Form...? (You must click in the holdiday table before doing so)

  5. #5
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bespoke scrollbars in a worksheet (2003 sp2)

    Thanks Hans

    I had not thought of that

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

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