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 |
#2
|
|||
|
|||
Hi Jan,
Word has no 'hide' row function and you can't actually make the row heights = 0 either, though you can come close to it. Depending on what you're trying to achieve, you might need to delete the offending row(s). Cheers "Jan" wrote in message ... 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004 |
#3
|
|||
|
|||
Hi ?B?SmFu?=,
: How can I hide table rows using vba? If you format the entire row as "hidden" (Format/Font) the row will disappear (assuming you disallow display of things formatted hidden in Tools/Options/View (or VBA equivalent)) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
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 |