+ Reply to Thread
Results 1 to 3 of 3

Hidden/Visible sheets in listbox

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    Maryland, US
    MS-Off Ver
    Excel 2003
    Posts
    5

    Hidden/Visible sheets in listbox

    Hi,
    I'm trying to create a userform that allows the user to swap sheets from visible to hidden status. I've made it to the point where all the sheet names are populated based on their current status in their respective listbox, but I am stuck on using the results of any swaps to newly set their visible property. the code I have in the userform is as follows:

    Please Login or Register  to view this content.
    The sheets are added to the correct column based on the current visible/hidden status with the following code in Module1

    Please Login or Register  to view this content.
    The part I'm having trouble with is taking the names of the sheets that are in the list and setting them to visible/hidden based on their new status (the part of the code that is commented out in the first code section). I've attached a sample workbook with the code as it currently exists.
    Attached Files Attached Files
    Last edited by DRoberts; 09-23-2009 at 08:19 AM. Reason: solved

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Hidden/Visible sheets in listbox

    Try this in place of your OKButton_Click() Sub

    Please Login or Register  to view this content.
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

  3. #3
    Registered User
    Join Date
    08-04-2009
    Location
    Maryland, US
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Hidden/Visible sheets in listbox

    Works perfectly, thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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