hide/unhide rows

  1. J

    VBA to unprotect sheet, hide/unhide rows based on column A value=1, then protect sheet for multiple sheets

    Greetings. I have a schedule tool created and struggling to find the right code. We have a sheet named "Associates" and will have a button on this sheet to link a macro module to update a number of other sheets. There are 7 protected sheets, let's just say "Sheet 1", "Sheet 2", "Sheet 3" etc...
  2. J

    Hide/Unhide variety of ranges of rows based on cell value in dropdown list (Dynamic)

    Greetings. I have a spreadsheet to calculate incentive pay based on title. The title is pulled from a data validation list in cell F7. There are 10 possible titles and when selected, i want a variety of ranges of rows to be hidden. The hidden rows may be different for multiple titles. There...
  3. J

    Hide/Unhide Macro causing Group Boxes containing Option Buttons to overlap

    Hi, Fairly new to VBA/Macro usage. I'm developing a dynamic questionnaire with Option Buttons and Check Boxes where, depending on the responses to each question, the macro would hide/unhide rows making other followup questions available. My issue is, when hiding rows, the group boxes containing...
  4. N

    Code to Hide / unhide Rows in excel

    Good Afternoon, i am little bit new to VBA code. I am working on an excel sheet with different contract Articles, I need to have a code when i double click on the Article heading it hides all its sub Articles, and double click again it unhides them. the problem is i need to repeat this code to...
  5. J

    Dynamic conditional hide/unhide rows in particular ranges

    Hi folks, Have been struggling fruitlessly with code copied from similar examples for a couple of days, but no luck. My worksheet has 50 boxes (ranges). See screenshot below (I couldn't see a way to upload the file, sorry). Basically, i want unused rows in each range to be hidden until my user...
  6. M

    VBA Hide/Unhide rows on other sheet

    Can someone please help me with the below code: Private Sub Worksheet_Change(ByVal Target As Range) With Sheets("Sheet2") Select Case Target.Address(False, False) Case "B12" .Rows(14).Rows.Hidden = Target.Value = "" .Rows(34).Rows.Hidden = Target.Value = ""...
  7. T

    Hide/unhide rows with buttons

    I am using several toggle buttons to hide/show rows of data related to the specific toggle buttons. I also want to hide and show the toggle buttons as well. When I try to do that the data underneath the toggle buttons is hidden but the toggle buttons don't hide with the cells. A solution for...
  8. J

    Macro hide/unhide rows by name toggle button

    Hi all, I am wondering if a macro could hide/unhide rows by a caterogry. To be clear, I have Names in the D column, let's for simplicity say there are 2 names nancy and in a different row there's sue and there are multiple instance of them on many different rows. I wish to be able to hit a...

Watch MrExcel Video

This Week's Hot Topics

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
Top