+ Reply to Thread
Results 1 to 2 of 2

need macro to hide/unhide columns through multiple checkboxes

  1. #1
    Registered User
    Join Date
    03-16-2012
    Location
    Wellington
    MS-Off Ver
    Excel 2010
    Posts
    20

    need macro to hide/unhide columns through multiple checkboxes

    Hi, I need a way for users to select a range of criteria (am trying to do it with checkboxes but open to suggestions) that will display on a graph. The criteria not selected will need their rows to be hidden so that the legend does not show on the graph.

    Attached is a spreadsheet where I am able to select (hide/unhide) the criteria in col A ie appt types. These checkboxes hide a number of columns that are adjacent. I want to be able to select from those types and then select various regions to compare them for the given criteria. This involves hiding non-adjacent columns and it may also be asking it to hide a column already hidden by the selection of criteria.

    the columns to be hidden/unhidden are HM - OS

    I know very little coding so please keep any suggestions geared to a learner. thank you.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-16-2012
    Location
    Wellington
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: need macro to hide/unhide columns through multiple checkboxes

    Hi, I've found a way to work around the problem rather than solve it so will not look for help with this now. thanks.

+ 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