Results 1 to 9 of 9

Toggle Button for Hiding/Unhiding rows

Threaded View

  1. #1
    Registered User
    Join Date
    11-18-2009
    Location
    Qatar
    MS-Off Ver
    Excel 2003
    Posts
    21

    Toggle Button for Hiding/Unhiding rows

    Hello Guys,
    Need your help again.

    I am trying to figure out how to hide rows automatically when 1 row or more rows have zero (0) values and/or blank.
    Have attached here a working file for reference.

    What I'm doing now is entering data in Sheet1(a) and/or Sheet2(a). Data here are linked to the printed sheet-Sheet1 and Sheet2.
    Every month I will be printing this printed sheets numbering 10 or more and I will be adding more sheets to be printed in the future.
    Before printing, I have to hide row/s having all 0 values across calculated, for all the 10 or more printed sheets. (e.g. In Sheet1, rows 10, 16, 19, 23 and 37). So this takes time.
    Note that the columns in the printed sheet will probably remain the same.

    For this, is it possible as well for a toggle button to be utilized for all the codes in the printed sheets to run-a. hide the rows with 0s when toggle on and unhide the rows when toggle off. Likewise, the caption will change between toggle.

    This toggle button is placed in a summary sheet, but for this purpose, is placed in 1 - worksheet.

    Can you guys help me code this?

    Thanks in advance for the great help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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