selecting workbook/sheet

Discussion in 'Excel' started by msnarayanan, Sep 29, 2016.

  1. msnarayanan

    msnarayanan

    Joined:
    Aug 19, 2016
    Messages:
    5
    Likes Received:
    0
    dear all

    i have created a workbook with 7 or 8 sheets.
    while some sheets are protected, the other sheets are for data entry.
    the protected sheets are for viewing/printing only. the fields are picked up from the data tables.

    i wonder is it possible to select and open the specied sheets by a click of the button - say
    menu driven table.

    the table may look as below:

    1. Data entry for Sales - if this is clicked it should open the
    corresponding sheet in the workbook
    2. Data entry for Purchases - as above
    3. View Print Consolidated Sales
    etc.

    i can select the sheets by clicking the respective files, appearing at the bottom. but for
    presenting the options, in a better looking menu.

    your help and advice is sought.

    m s narayanan
     
    msnarayanan, Sep 29, 2016
    #1
    1. Advertisements

  2. msnarayanan

    Becky Administrator

    Joined:
    Aug 3, 2011
    Messages:
    34
    Likes Received:
    3
    You can insert hyperlinks into your workbook, and I think that would do what you are looking to achieve.

    Type the link text, then with the cell highlighted go to the Insert tab, and click on Hyperlink. Within the options menu select 'Place in this document' - you can then specify which sheet and which cell. Finish by pressing OK to create the link.
     
    Becky, Sep 30, 2016
    #2
    1. Advertisements

  3. msnarayanan

    msnarayanan

    Joined:
    Aug 19, 2016
    Messages:
    5
    Likes Received:
    0
    dear becky
    thanks for your help. the suggestion made by you did work.
    one more help - the hyperlink shows all the sheets in the workbook.
    as data for each sheet is entered by different staff, i wonder whether
    i can createa hyperlink only to show a specific sheet - instead of
    all sheets in the workbook.

    m s narayanan
     
    msnarayanan, Sep 30, 2016
    #3
  4. msnarayanan

    Becky Administrator

    Joined:
    Aug 3, 2011
    Messages:
    34
    Likes Received:
    3
    I'm afraid I don't know of a way to do that :(
     
    Becky, Sep 30, 2016
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. tskelton75
    Replies:
    0
    Views:
    605
    tskelton75
    Nov 16, 2011
  2. tskelton75
    Replies:
    0
    Views:
    245
    tskelton75
    Nov 16, 2011
  3. jushin100
    Replies:
    1
    Views:
    950
    madonaalbert
    Jun 21, 2012
  4. peshy12
    Replies:
    1
    Views:
    807
    dallton
    Dec 31, 2012
  5. dubgurl
    Replies:
    1
    Views:
    257
    XLPadawan
    Jun 9, 2016
  6. JChauhan
    Replies:
    0
    Views:
    146
    JChauhan
    Aug 11, 2016
Loading...