Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: VBA Code for Selecting sheets

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Florida
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Please help...
    Have a workbook w/ 32 sheets. Would like a drop down box on page 1 that lets you choose which sheet you want vs. scrolling through all those tabs. And ideas?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Friend,
    Download file nos 8

    http://www.pexcel.com/download.htm

    name of the file is 'Sheet Names'

    i think this can help you..


    other way to go around is:
    right click on the sheet navigation button and you will get the names of all the sheet.

    ni****h desai
    http://www.pexcel.com

    [ This Message was edited by: nisht on 2002-04-03 05:54 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Florida
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, however the utility will not be on the users computer. I was hoping for VBA code so the sheet selection module would be included in the end users workbook.

    Thanks for the reply.

    SB
    On 2002-04-03 05:53, nisht wrote:
    Friend,
    Download file nos 8

    http://www.pexcel.com/download.htm

    name of the file is 'Sheet Names'

    i think this can help you..


    other way to go around is:
    right click on the sheet navigation button and you will get the names of all the sheet.

    ni****h desai
    http://www.pexcel.com

    [ This Message was edited by: nisht on 2002-04-03 05:54 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Speedboy
    I use check boxes on an intro screen. All the sheets are hidden until I check which one I want. It then appears. If you are interested re-post and I will step you through it.
    George

    Learn to listen. Opportunity sometimes knocks very softly.

  5. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Speed boy


    You may already know this, but you can right click on the 'tab scrolling buttons' to get a pop-up sheet menu.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    My sheet is now not password protected you can download it and study the code.

    It is a example utility.

    ni****h desai
    http://www.pexcel.com

  7. #7
    New Member
    Join Date
    Mar 2002
    Location
    Weathersfield,VT
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    George, I would appreciate your check box input, as I would like to add those to my workbooks. Thanks in advance. Bob


    On 2002-04-03 06:05, GeorgeB wrote:
    Hi Speedboy
    I use check boxes on an intro screen. All the sheets are hidden until I check which one I want. It then appears. If you are interested re-post and I will step you through it.

  8. #8
    New Member
    Join Date
    Apr 2002
    Location
    Florida
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Great code... How do I modify this to affect only the workbook where needed rather than a utility?

    The help is greatly appreciated.
    SB
    On 2002-04-03 06:11, nisht wrote:
    My sheet is now not password protected you can download it and study the code.

    It is a example utility.

    ni****h desai
    http://www.pexcel.com

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    George

    Learn to listen. Opportunity sometimes knocks very softly.

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OOPS
    Got timed out again.

    Hi Bob (Stargazer)

    Sorry for the delay responding. Been out of town.
    Here goes. I will step you through the procedure for one check box on a fresh workbook.
    Adjust and multiply to suit.
    Open a fresh workbook. From the forms toolbar place a checkbox on the sheet. Adjust it for size, caption etc. Right click on the check box and choose “Format control” Click on the “Cell link” box and choose a cell to link to. Lets assume H5 (put it any where you want but the code has to refer to the chosen cell). Put the following code into a standard module. Next right click on the checkbox, choose “Assign macro” click on this macro and press OK. Done

    Public Sub HideMySheet()
    'These routines hide or show the named sheets according
    'to the condition of the corresponding check box on
    'the INFO sheet
    On Error Resume Next
    Application.ScreenUpdating = False
    Sheets("MySheet").Visible = Range("H5").Value
    End Sub

    George

    Learn to listen. Opportunity sometimes knocks very softly.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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