Home |
Search |
Today's Posts |
#1
|
|||
|
|||
using vba to hide rows in a table
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row height problem with table in table | Tables | |||
Table: Setting default: Heading rows repeat and keep with next | Tables | |||
table caption numbering | Tables | |||
Can Table AutoFormat apply formatting to multiple heading rows? | Tables | |||
consecutive Table Rows with different # of columns of different widths | Tables |