hide/unhide columns

  1. J

    Hiding and Unhiding Columns based on multiple drop down lists

    Hi Gurus, I have a stomper. I am trying to hide/unhide columns based on three different drop down lists. The below formula works to hide/unhide when individual drop down lists are selected, however does not work together to "filter down" and show only the columns that apply when all three...
    • JoRyBar
    • Thread
    • drop drop downs end hide/unhide columns target.value
    • Replies: 0
    • Forum: Excel Questions
  2. A

    Hide/Unhide toggle button which changes colour and text in vba

    Hello I've been trying to write some VBA to set up a toggle button to hide multiple predefined columns. I initially managed to define the code for the hide/unhide toggle and attached this to a shape I then wanted a toggle button which would then change the colour of the button and text...
    • Arrow081974
    • Thread
    • button change color button change text on button hide/unhide columns toggle button
    • Replies: 3
    • Forum: Excel Questions
  3. S

    Hide columns based on values in two seperate cells

    Hi everyone, I had great success with my last query on this site (thanks to the great experts here!) and I have another VBA problem which I’m struggling with. Basically I have data in columns E to AH (30 columns total), every ten columns is a new category for me. Categories are as follows:-...
  4. J

    ActiveX Check Boxes: hide/unhide columns when 1 or more boxes are checked

    Hello, I have 3 ActiveX Check Boxes named "Red," "Green," and "Blue" that will unhide and hide columns when the value in a row meets the criteria identified in the code. When 1 box is checked and unchecked, the result is good (check the box and the correct columns are unhidden, uncheck the box...
    • jrenee
    • Thread
    • check box in excel check/uncheck hide/unhide columns macro
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top