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")

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 !

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

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.

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

Winon: You da' man !

Gti182 will be very pleased.

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.

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.

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

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.

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.

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.