DougTucker
Technical User
I have an Excel workbook with a combo box to choose a value. The form triggers VBA to selectively hide or display certain rows that apply to the selection (the rows contain groups of check-boxes that are also hidden with the rows). This works fine on the screen, but as soon as I print the form, the check-boxes from the hidden rows all become visible and land on top of existing text.
How can I keep the check-boxes hidden when the rows are hidden? I've checked the property to "Print Object" (because I DO want it to print when it's displayed). I just don't want it to print when it's hidden.
Thanks in advance for your help.
How can I keep the check-boxes hidden when the rows are hidden? I've checked the property to "Print Object" (because I DO want it to print when it's displayed). I just don't want it to print when it's hidden.
Thanks in advance for your help.