+ Reply to Thread
Results 1 to 5 of 5

Question - How to hide specific rows in a word table

  1. #1
    Registered User
    Join Date
    01-28-2013
    Location
    Sussex, England
    MS-Off Ver
    Excel 2003
    Posts
    17

    Question - How to hide specific rows in a word table

    I am far more familiar with Excel than word, however, on this occasion I would like to hide specific rows in a table.
    What syntax should I use to select a specific row and then hide it?

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,875

    Re: Question - How to hide specific rows in a word table

    Word and Excel do not share equivalent functionality. There is no such thing in Word as hiding table rows and columns like Excel. However, you can format the text as Hidden and it will have the same effect. Highlight the rows you want to hide, then to go Home, the Font panel, click the arrow in the bottom right of the panel to bring up the Font menu, then click the Hidden checkbox.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-28-2013
    Location
    Sussex, England
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Question - How to hide specific rows in a word table

    Thanks for the prompt reply, however, I should have been a bit clearer with the question as I want to be able to do this using VBA code, hence the question about the syntax.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,875

    Re: Question - How to hide specific rows in a word table

    Sorry, I missed that the question was in a VBA forum.

    How do you want to determine the row to hide? This will hide whatever text is selected:

    Please Login or Register  to view this content.
    Last edited by 6StringJazzer; 12-12-2021 at 05:01 PM.

  5. #5
    Registered User
    Join Date
    01-28-2013
    Location
    Sussex, England
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Question - How to hide specific rows in a word table

    What I am trying to do is hide certain rows, depending on what a user selects from a list of buttons.
    I kind of got it to work perfectly for only one combination of rows (lets say for example rows 2, 3 & 5), however, when I try to choose a different combination of rows (lets say for example (1, 4 & 7), the function does something odd from there on and makes all rows from 1 to 6 invisible and only shows 6 and 8.
    When I delete the table and re-insert it, and try to make rows 1, 4 & 7 invisible, it works
    I then make all rows visible and then try making rows 2, 3 & 5 invisible, the function does something odd from there on and makes all rows from 1 to 6 invisible and only shows 6 and 8.

    Here is my Code for my declarations;
    Please Login or Register  to view this content.
    Here is my code for my buttons
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Here is my code to show all the rows;
    Please Login or Register  to view this content.
    and here is the main bit of code that does the hiding;
    Please Login or Register  to view this content.
    The table so far is a simple 1 column 8 row table.

    My aim is to click a button, make all rows visible momentarily, then only make the selected rows invisible.
    But it seems like the table get corrupted if I try one combination followed by another.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to hide some rows based on a specific cell value whilst keeping all unused rows hidden
    By Consultant101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2021, 06:41 PM
  2. [SOLVED] New Question to Hide Rows with Toggle button and auto adjust for additional rows
    By The Phoenix in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-14-2015, 01:55 PM
  3. Replies: 2
    Last Post: 10-30-2014, 01:49 AM
  4. Hide multiple sheets from a list if a specific word is used.
    By Andrewrimell88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2014, 07:04 AM
  5. [SOLVED] Hide specific Rows in Sheet1 + hide 5 more in Sheet2
    By bluesurger in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-02-2014, 07:19 AM
  6. hide columns if a cell has a specific word
    By tlacloche in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-17-2014, 08:06 PM
  7. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1