Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jan
 
Posts: n/a
Default 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   Report Post  
macropod
 
Posts: n/a
Default

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   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Row height problem with table in table Stephanie T. Tables 0 November 23rd 04 03:35 PM
Table: Setting default: Heading rows repeat and keep with next Clive Long,UK Tables 3 November 15th 04 07:41 PM
table caption numbering scottkinsey Tables 1 November 11th 04 11:47 AM
Can Table AutoFormat apply formatting to multiple heading rows? aubreyco Tables 1 November 10th 04 05:02 PM
consecutive Table Rows with different # of columns of different widths || cypher || Tables 2 November 10th 04 02:06 AM


All times are GMT +1. The time now is 09:44 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"