+ Reply to Thread
Results 1 to 5 of 5

Toggle Button to hide multiple Columns and Rows

  1. #1
    Registered User
    Join Date
    06-26-2019
    Location
    Detroit
    MS-Off Ver
    Windows 10
    Posts
    5

    Toggle Button to hide multiple Columns and Rows

    Hello,

    I'm trying to figure out the correct coding for a toggle button that will hide/unhide multiple columns and rows. Specifically, I need the toggle button to hide columns J:M, P:S, V:Y, however when these columns are hidden I need rows 72:82 to be visible. When J:M, P:S, V:Y are visible, I want rows 72:82 to hide. Is there a way to do this with only one toggle button?

    Thanks!

    ***I attached the excel file im currently working on.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    Re: Toggle Button to hide multiple Columns and Rows

    try this and see if it works for you:

    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,870

    Re: Toggle Button to hide multiple Columns and Rows

    Maybe
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-26-2019
    Location
    Detroit
    MS-Off Ver
    Windows 10
    Posts
    5

    Re: Toggle Button to hide multiple Columns and Rows

    Thanks for the responses. I was able to figure it out. I used this code;


    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,870

    Re: Toggle Button to hide multiple Columns and Rows

    Glad you sorted it & thanks for the feedback

+ 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. [SOLVED] Button to toggle Hide/Show multiple columns
    By lougs7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-01-2018, 04:48 PM
  2. Toggle Button to Hide Rows
    By tryingtoexcelatexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2018, 04:25 AM
  3. [SOLVED] Hide Rows that are below a button (and be able to toggle)
    By Kistler2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-06-2016, 10:24 AM
  4. [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
  5. Show/Hide Rows & Columns Toggle Button
    By axegrynder in forum Excel General
    Replies: 2
    Last Post: 06-29-2015, 06:38 PM
  6. button to toggle hide/unhide columns
    By dbuff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2013, 07:56 PM
  7. Hide/Unhide Multiple Sets of Columns with Toggle Button
    By Mischief433 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-06-2012, 05:55 AM

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