+ Reply to Thread
Results 1 to 3 of 3

how to switch between sheets using cell value and clicking on them

  1. #1
    Registered User
    Join Date
    06-09-2013
    Location
    lebanon
    MS-Off Ver
    Excel 2007
    Posts
    95

    how to switch between sheets using cell value and clicking on them

    hello everyone i been recently trying to switch between sheets using cell value, which is clickable, say i have sheet1 sheet2 sheet3 by default, and im currently in sheet1, i want to jump to sheet2 using a cell by clicking on it, is it possible? i want to design it to look like a flash.

    p.s i have MS 2007

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: how to switch between sheets using cell value and clicking on them

    Use hyperlinks..

    http://office.microsoft.com/en-001/e...005209116.aspx
    http://spreadsheets.about.com/od/exc...s-tutorial.htm
    http://www.contextures.com/excelhyperlinkfunction.html
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    06-09-2013
    Location
    lebanon
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: how to switch between sheets using cell value and clicking on them

    hey! it worked! thx !

    i got to know how to use the hyperlinks kind of cool adding flash shapes and writing on them with wordart and setting the wordart and shape a hyperlink to it so i can go to other sheets just by clicking on them!
    Last edited by raffi123; 06-10-2013 at 08:39 AM. Reason: it worked but cant reply

+ 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