macro hide

  1. S

    Macro to update, hide and save

    Morning, I have developed the following Macro in order to- update, hide some columns and save the file. But, it keeps giving me the following error: This action will cancel pending data updates. Would you like to continue?- And, it does not matter whether yes or no, because the data is not...
  2. S

    Unhiding next column

    Hi, I have a master sheet with Columns dated across starting from 01/07/16 in Cell B1, 02/07/16 in Cell C1 and so on across. I have charts that are connected with the master sheet and I want it to update each day with only data that is entered so that the charts arent showing loads of empty...
  3. G

    macro to hide all rows with specific text in column B.

    Hi, I am looking for a macro to hide all rows that have the word "detail" in column B. This will ultimately be assigned to a button. I feel like this should be an easy one, but I seem unable to get the If function to work. Any help is appreciated.
  4. R

    Need auto hide rows macro to also hide Forms Check Boxes

    Hi I have a macro that sits within different sheets in my workbook and hides rows based on the result in a cell. I thought this was great until I added in Forms Check Boxes yesterday and found that rather than hide, these boxes just move down the page. Is there any way to get the check boxes on...

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