Results 1 to 6 of 6

Macro to Hide/Unhide Cells

Threaded View

  1. #1
    Registered User
    Join Date
    08-07-2016
    Location
    Edmond, Oklahoma
    MS-Off Ver
    2010
    Posts
    15

    Macro to Hide/Unhide Cells

    I am wanting to create a macro (that will be attached to a button) where I can hide/unhide rows based on if they have a zero value in a certain column. I have attached an example workbook which shows two separate value sets (rows 10-30 and 34-59) where if there is zero value in column G, I want to be able to run the macro to hide the rows with a zero. I also want to be able to run the same macro to unhide, so sort of like an on/off switch.

    Any help creating this macro would be greatly appreciated!

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide/unhide rows checkbox hide but doesn't unhide
    By windzor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2021, 11:51 AM
  2. Hide/Unhide Cells
    By mandy03 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2018, 06:02 PM
  3. [SOLVED] Macro for Hide blank rows and Unhide the rows with cells
    By Neilesh Kumar in forum Excel General
    Replies: 4
    Last Post: 04-12-2017, 06:06 AM
  4. Macro Merging VBA how to hide and unhide two groups of cells
    By Lmao in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2017, 02:49 PM
  5. Hide Visibility hide and unhide menu using macro ?
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2015, 09:05 PM
  6. Macro to hide/unhide cells not running or running slow
    By mbp727 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2013, 04:22 PM
  7. macro to hide/unhide cells
    By aviflux in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2008, 10:37 AM

Tags for this Thread

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