+ Reply to Thread
Results 1 to 5 of 5

Populate Combobox with Worksheet Names EXCLUDE hidden

  1. #1
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    110

    Populate Combobox with Worksheet Names EXCLUDE hidden

    Hi

    I have a code that shows all the sheet names in a workbook. How do I exclude the hidden sheets?

    Please Login or Register  to view this content.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Populate Combobox with Worksheet Names EXCLUDE hidden

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    110

    Re: Populate Combobox with Worksheet Names EXCLUDE hidden

    Quote Originally Posted by 6StringJazzer View Post
    Please Login or Register  to view this content.
    Thanks for your response!
    Will try it out!

  4. #4
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    110

    Re: Populate Combobox with Worksheet Names EXCLUDE hidden

    Worked llike a charm!

    I just needed to change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Thank you!!

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Populate Combobox with Worksheet Names EXCLUDE hidden

    Oh, man, I'm sorry about that. I did it from memory without testing and had the wrong attribute. Glad you worked it out!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform combobox used to populate and edit records does not recognize duplicate names
    By SLJones in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-07-2013, 05:56 PM
  2. how to populate from combobox to worksheet
    By dan2010 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-26-2010, 07:19 AM
  3. populate userform combobox with sheet names
    By tapapad in forum Excel General
    Replies: 3
    Last Post: 11-14-2008, 03:10 AM
  4. Populate combobox with Range names - xl2003
    By elcentro3m in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-16-2007, 12:06 PM
  5. Populate combobox with Range names - xl2003
    By elcentro3m in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2007, 06:44 PM

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