+ Reply to Thread
Results 1 to 20 of 20

hiding rows which contain checkboxes but checkboxes don't hide as they should

  1. #1
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    hiding rows which contain checkboxes but checkboxes don't hide as they should

    Hi All,

    I'm currently dealing with a very frustrating issue relating to hiding rows which contain checkboxes.

    There is some code which hides various rows some of which contain checkboxes.

    Depending on checkbox setting:
    1) move but don't size with cells - it doesn't hide all checkboxes correctly (some remain)
    2) Move and size with cells - it hides all checkboxes but some are not fully hidden

    I've attached the said file with 2 tabs, one with each of the settings above.

    Issue should be apparent when clicking the 3rd macro button ("Hide rows based on Column F")
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,283

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    I looked at your project and found that it is, for some reason, placing an asterisk in Column F each time you hide the rows.

    First it was row 31, I manually deleted that asterisk - hid the rows - then the asterisk moved to the next lowest blank cell with a checkbox. After doing this several times, it worked down to row F35 creating an asterisk where an asterisk not previously present .

    As I indicated, I don't understand how it is doing that. Time for a Forum Guru to step in. Hope this information helps them.

    All the best !

  3. #3
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Not quite sure I follow Logit, there's no asterisk in row F31?

    When you run the hide macro it should hide all rows which don't contain an asterisk in columns F

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,283

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Clear all the cells in Col F that contain an asterisk. Then "hide" the rows. When I did it, the program was inserting a few asterisks back into Col F, when previously they had been removed by me. I'm hoping it's not computer that did that.


  5. #5
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Oh think I follow now, I'll try that tomorrow when I'm back at the computer to see if i get he same

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Hi Gti182,

    I have amended your code in the Module below:

    Please Login or Register  to view this content.
    Please see if the attached Workbook works for you now.

    Regards.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,283

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Winon: You da' man !

    Gti182 will be very pleased.

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    @Logit,

    Thank you Logit, lets hope we are right!

    Kind Regards.

  9. #9
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,283

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Works great on my computer. So glad too ... 'cuz I just bought this new a month or so ago and his original posting didn't work well. Phew ! Dodged that bullet.

  10. #10
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    I have updated the Code with a Screenupdate toggle,and attached a revised sample Workbook.

    @Logit,

    A new computer properly setup is always a pleasure to explore, test and enjoy!

    Regards.
    Attached Files Attached Files

  11. #11
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    thanks for the help Winon but looks like i wasn't clear enough on the issue. The code for unhide and hide rows within module 1 works fine (these link to buttons in cells L2 & L3 marked code works fine) - this bit of code only works on Asterisk's in column E. Apologies i should have removed these to avoid condusion.

    To be clear i'm only looking at what happens when clicking the "Hide rows based on Column F" button which is linked to the "test" macro within module 3.

    The code hides rows without an Asterisk as it should but i'm left with the checkboxes still being visible after their respective rows are hidden.

  12. #12
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Hello Gti182,

    Thank you for the clarification.

    In the Workbook as you have provided in Post#1, replace Module 3 with the Code below:

    Please Login or Register  to view this content.
    Regards.

  13. #13
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Still the same issue i'm afraid. I'm now wondering if it's a excel version issue?

    I'm currently using excel 2010 version 14 32bit.

    I've attached screenshots of how it looks on my machine
    Attached Images Attached Images

  14. #14
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Hi Gti182,

    Still the same issue i'm afraid. I'm now wondering if it's a excel version issue?

    I'm currently using excel 2010 version 14 32bit.
    That is not the problem.

    The Screenshots tell me you have Clicked the "Hide Checkbox Rows", correct?

  15. #15
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    correct, this is after the hide "test" macro has been run.

    This is showing my view of the issue i.e. when the rows are hidden the checkboxes that were in them aren't always hidden or only partially hidden.

    easy way to see my issue is if you manually hide row 39 in both sheets. In the first sheet the checkbox remains, in the second sheet the checkbox is only only partially hidden but still visible

    This is why I suspect this issue relates to a setting rather than the code itself.
    Last edited by Gti182; 12-02-2016 at 08:44 AM.

  16. #16
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Hi Gti182,

    This is showing my view of the issue i.e. when the rows are hidden the checkboxes that were in them aren't always hidden or only partially hidden.
    I have made a few changes to your Code, to solve this issue.

    Please see if the revised attached sample Workbook is now closer to your requirement.

    Regards.
    Attached Files Attached Files

  17. #17
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Thanks for looking at this Winon. Had a look at the file and your code hides all checkboxes in the sheet.

    I only want to hide the checkboxes that exist in the hidden rows i.e. hide row and the checkbox within it if one exists.

  18. #18
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Hi Gti182,

    I only want to hide the checkboxes that exist in the hidden rows i.e. hide row and the checkbox within it if one exists.
    Then this Workbook should do it.

    Regards.
    Attached Files Attached Files

  19. #19
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Thanks for the help Winon but it doesn't look to be working as i was hoping.

    I think i'm going to go down the route of manually hiding the checkboxes in the rows that are hidden to avoid this issue.

  20. #20
    Registered User
    Join Date
    08-07-2019
    Location
    Chile
    MS-Off Ver
    365
    Posts
    8

    Re: hiding rows which contain checkboxes but checkboxes don't hide as they should

    Hi,

    I am new to this forum and I don't know where I can ask my question, that's why I do it here, since it has to do with what they were talking about.

    I have a problem with the code they put to show the Checkboxes after they were hidden.

    This is the code that gives me problems.

    Sub UnHideColumns ()

    Columns ("D: AL"). EntireColumn.Hidden = False

    ActiveSheet.CheckBoxes.Visible = True

    End Sub



    when I run it, it shows me the boxes on the form, but I get an error message that says:

    << There was an error "1004" at runtime:

    The visible property of the CheckBoxes class cannot be assigned. >>

    Thank you very much for your help!

    I also leave the file in case they need it.
    Attached Files Attached Files

+ 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] Help Needed with Checkboxes to Hide or Unhide Rows
    By dgibney in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-25-2014, 11:39 AM
  2. [SOLVED] Hide/unhide rows with checkboxes
    By mixer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2014, 03:58 PM
  3. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM
  4. [SOLVED] Automatically Hiding rows based on checkboxes
    By Jake Bierly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2012, 06:08 PM
  5. Hide rows AND checkboxes in that row with code/macro
    By Riqueza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2012, 05:38 AM
  6. Hiding rows, but checkboxes aren't hidden
    By kid_epicurus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2012, 02:46 PM
  7. Hiding and Unhiding a Dynamic Range of Rows Using Checkboxes
    By markymark84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2012, 11:51 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