hide/unhide row

  1. J

    Hide/ Unhide Rows based on Text Value - Checkbox

    Hi All, Can someone please help me to hide/ unhide rows on another sheet based on Text Value? For example, if 'Purchase Order' is enabled using a checkbox or a button, then rows containing 'Purchase Order' in a specific column, in this case Column D, will be shown. Note: I am trying to make...
  2. D

    Macro to Hide Certain Rows with the Click of a Button, and other Rows with the Click of Another Button?

    Hello, I have a spreadsheet that is broken into costs for Canada and for the US. I don't know much about Macros, but am hoping to use a macro to hide all the rows that relate to an American cost when you click a button that might say "Canada" for example. And I'm hoping to have another button...
  3. W

    Macro to automatically update

    Hello, This is a long post, if you are too lazy, here is the issue. Need to make automatic changes to cells that will activate a "Run when Values Change Macro" without going into a loop forever. Getting "The object invoked has disconnected from...." when I've tried to link it I've got a job...
  4. M

    Auo Hide/Unhide Rows Using Macro

    Hello All, I am working on a spreadsheet "B" in excel and I need to be able to hide/ unhide rows that dont have a value in them.( The rows are linked to another sheet "A" in the workbook) I would like to be able to have the rows in sheet "B"unhide when I enter information into my table on sheet...
  5. S

    Help! Alter macro to automatically hide/unhide

    I have this macro that adjust lines accordingly to the # chosen in the drop down box (using data validation). Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Long If Not Intersect(Target, Range("d1")) Is Nothing Then Range("A10:A1793").EntireRow.Hidden = True r...

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