J
Jan
Hi All,
I've got a question: How can I hide table rows using vba?
I've the following table:
--------------------------------------------------
| row1 | header |
--------------------------------------------------
| row2 | O hide_line_3 |
| | O hide_line_5 |
--------------------------------------------------
| row3 | O hide_line_4_and_5 |
--------------------------------------------------
| row4 | Text abcd |
--------------------------------------------------
| row5 | Text defg |
--------------------------------------------------
Where the O's are option buttons.
So in the on change event of hide_line_3 I want to show/hide line 3.
So in the on change event of hide_line_5 I want to show/hide line 5.
So in the on change event of hide_line_4_and_5 I want to show/hide line
4_and_5.
I tried already to make the heights 0, but it will mix up the format of the
other rows with the option buttons...
Any ideas? Every sugestion is welcome!!
Thanks!
jan
I've got a question: How can I hide table rows using vba?
I've the following table:
--------------------------------------------------
| row1 | header |
--------------------------------------------------
| row2 | O hide_line_3 |
| | O hide_line_5 |
--------------------------------------------------
| row3 | O hide_line_4_and_5 |
--------------------------------------------------
| row4 | Text abcd |
--------------------------------------------------
| row5 | Text defg |
--------------------------------------------------
Where the O's are option buttons.
So in the on change event of hide_line_3 I want to show/hide line 3.
So in the on change event of hide_line_5 I want to show/hide line 5.
So in the on change event of hide_line_4_and_5 I want to show/hide line
4_and_5.
I tried already to make the heights 0, but it will mix up the format of the
other rows with the option buttons...
Any ideas? Every sugestion is welcome!!
Thanks!
jan