+ Reply to Thread
Results 1 to 7 of 7

Hide/Unhide Check Box Help - Different

  1. #1
    Registered User
    Join Date
    02-01-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    9

    Question Hide/Unhide Check Box Help - Different

    I see where some users have asked about a single check box to hide/unhide multiple rows. I have played a bit with this but I need something a little different.

    I have a spreadsheet where on one tab (Bid Request Prices) it has all the data and formulas to set pricing for 102 different products. This information feeds another tab (2016 Bid Pricing). I would like to add a check box for each item on the Bid Request Prices tab that would hide/unhide the corresponding line on the 2016 Bid Pricing tab so that when we print or create a .pdf only the check items are on the list.

    I am a newb to a lot of this so if this is something simple that I should know I apologize now. Learning on the fly here. Thanks!

    Will I have to create a macro for each individual check box or is there a more dynamic code for this? In either case if you could help me with this I would appreciate your help!

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Hide/Unhide Check Box Help - Different

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    02-01-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    9

    Re: Hide/Unhide Check Box Help - Different

    I can attach a sample of the workbook I am currently working with but I have no way of creating a sample of the desired results as this is very new to me.

    The first sheet is the sorce info and the second sheet is where i would like to have the lines hidden

    ForHelp.xlsx

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Hide/Unhide Check Box Help - Different

    Here's some code which should do what you want:

    Please Login or Register  to view this content.

    Run macro "MakeCheckBoxes" manually once, to create the checkboxes. Once that's run, you can simply tick / untick the boxes to show / hide the corresponding rows in the 2016 Bid Pricing worksheet.


    Edit: attachment added, to show it all working.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-01-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    9

    Re: Hide/Unhide Check Box Help - Different

    Wow thats awesome. It looks like that will do the trick. Now I just have to figure out why its giving me the "macro ma not be available in this workbook or all macros may be disabled" even though I have made all the changes in the trust center!

  6. #6
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Hide/Unhide Check Box Help - Different

    Quote Originally Posted by AreJay0711 View Post
    Wow thats awesome. It looks like that will do the trick. Now I just have to figure out why its giving me the "macro ma not be available in this workbook or all macros may be disabled" even though I have made all the changes in the trust center!
    If you have saved the workbook with a different name, then run the "MakeCheckBoxes" macro again - this links the macro (with workbook name) to each checkbox.

  7. #7
    Registered User
    Join Date
    02-01-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    9

    Re: Hide/Unhide Check Box Help - Different

    I will try that, but I am now getting that message on every macro I try to run. I am going to have to look into if this is a bug or if I am missing an update or not.

+ 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. Using check boxes to hide and unhide worksheets
    By J_barber in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-12-2017, 04:27 AM
  2. [SOLVED] Check Box - Hide / Unhide Information
    By KateMaz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2016, 07:29 AM
  3. Check Box - (Hide / Unhide worksheet)
    By batchy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-20-2014, 09:25 AM
  4. check box hide or unhide rows/column
    By makhdoomliaqat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2013, 08:15 AM
  5. Hide or Unhide worksheets in a workbook using check boxes
    By Kempfat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-14-2012, 05:35 AM
  6. Hide/unhide row using check box ***PLEASE HELP***
    By madaleck1 in forum Excel General
    Replies: 6
    Last Post: 09-22-2011, 02:31 PM
  7. [SOLVED] Check Box Macro to hide and unhide a column
    By Daphne in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-26-2006, 08:55 AM

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