Hi
I have some code which hides rows based on the entry into a cell, this works using the "Worksheet_Change(ByVal Target As Range)" and "case", however I can't get that to work when I want to hide a checkbox. Here is a sample of the code:
The code I have for checkboxes is:
However I can't get this to work when I include it at the end of a case. I've tried simply hiding the rows where the checkboxes are however they all bunch together and are still semi visible. The checkboxes I'm using are the activexcontrol type.
Any ideas?
Thanks
Bookmarks