This helped quite a bit! I think I came up with a bit of a different solution and instead just figured out how to delete the entirety of column 1 instead of the individual check boxes, but I appreciate the help!



I have yet another question (I apologize for so many, but am glad you are helping because I feel like I am learning a lot). So I have attached a sample notebook in order to better explain this one. I have been asked if is possible that I add another checkbox that if check, would delete all of the contents of a section, leave the header, and display "Not applicable".

In the example document, currently they would have to select each checkbox in column 1 to remove a row based on what they do and do not what in the document. However, I was wondering if there was a way that they could select one checkbox in order to remove everything in the section below the header, but leave the header behind. They also want it to display "Not Applicable" if they were to select that checkbox.

Based on the sample document, I was hoping there is a way to select one checkbox in order to delete everything below the "Sample Header" sections, but still display the "Not Applicable" option. Even if there were 2 options, one to delete everything below the header, and one to display not applicable, that would be much better.

The current issue is that there might be 15 different rows underneath the header, and they do not want to have to select 15 different checkboxes if the entire section is not needed, they would rather just select 1-2 checkboxes in order to delete the contents, leave the header, and display not applicable.

Hopefully that helped to explain what I am trying to do, and I apologize if I repeated myself a lot. I also included the code I am currently using in the document, obviously if I need to add second column in order to have this additional option, I would need to delete rows 1 and 2, but that is the code I currently have.

Thank you once again, and I apologize for all of the questions!!

Attached Files

Sample Document for Help.docm (19.1 KB, 28 views)

Paul, I agree that hiding content also requires option settings but IMO it is far more useful and easy enough to include in the macro or a startup macro. I would be recommending moving the macro to run automatically on exiting the CC to allow the following functionality that the OP asked for.
Leaving the macro to run only when the form is complete makes that request pointless.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia