I have a spreadsheet where I am simply assigning the value of a CheckBox to a Range of Cells so later I can hide all that have a "False" value assigned to them. Currently I have the code under an AcceptButton but wondered if there is a cleaner way to get the same result with less code. One of my colleagues has told me that he believes I can do this by placing code in each CheckBox and under the Accept Button by using a sub routine. Here is a sample of the code currently only in the AcceptButton:
Please Login or Register to view this content.