Excel Macro VBA Tip 8 - Hide UnHide Rows and Columns in Excel with a Macro

Hi,

I have attached a file containing a feature I would like to use but do not know what it is called or where to find it. By clicking a + button users can unhide rows or columns. Click the - button and users can hide those same rows or columns?

Excel Feature.xls

Thanks in Advance,

Jordan

Hello,
I would like to create a Macro to attach to one button that would successively hide and unhide a specified row when pressed.

Thanks in advance for any help you can provide.

P.S. I am human.

Good morning,

Does anyone have a macro that I can assign to a button on a page? When the button is pressed, it will hide columns D, F, H, J, L, N, P, R on that page. When the button is pressed again, it will unhide the same columns. If necessary, I could use two buttons, one per event, but I would prefer one button if possible.

Thank you!

Robert

In my worksheet I have formulas in D35:CK35 that will result in "hide" or "show", what I would like is a Macro that when Run will hide the entire columns wherever the formula result is "hide". I'd also like to be able to click the button/run macro and then show all columns, so I can instantly switch from viewing all columns to only viewing those where the result is "show".

Many Thanks for any help,
Scoobyblue

I'm new to using Macros so I need some help with hiding and unhiding columns.

Basically what I'm trying to do is have the user select years of sales to compare.

If it's possible I would like the input the user enters on the INPUT tab in cells B3, B4 and B5 to unhide the appropriate column in the RAW DATA tab so that the chart compares the years selected.

So if the user selects 2007, 2008 and 2009 on INPUT tab then only columns D, E and F would be visible on the RAW DATA tab.

Thanks in advance for any help!

I have 12 columns for each month with various totals listed in rows. Between
each month I have columns for each day on the month. Those columns are
hidden for reporting and visual purposes. The monthly columns total of off
of the daily ones. Is there a way to create a macro that would work using a
short cut such as “Ctrl+1� for January “Ctrl+2� for February and so on that
would either hide the specified columns or unhide them.

Thanks,
Chance

I have a spreadsheet with a dropdown option in column A. I would like to write a macro to unhide columns B-C-D and hide E-F-G if choice "Fixed" is chosen in column A. If choice "Variable" is chosen in column A, then the opposite hide B-C-D and unhide E-F-G. Is this something that could be done with a relatively simple macro. I can record and edit macros, but have never written one from scratch

Thank you.

Hello to all!

In an effort to maintain the integrity of the print area of my report, I would like to give a user the ability to view specific columns:

i.e. I would only want these column(s) to appear by themselves at any given time....AD OR AE:AG OR AH:AJ. Being that these column(s) are at the end of the report, it wouldn't matter which one(s) end up last.

I created a few macros and assigned them to Buttons, which will work on the first go around, but if I select one of these more than once, I get a run time error.

Any suggestions?

Thank You,

Anthony

Hi,I'm looking for a macro to toggle (hide and unhide) every 8th, 9th & 10th column from H:J. So it should toggle H:J, Q:S, Z:AB and so on, all the way to columns BSY:BTA.I have very limited VBA experience and am really struggling with this.Can anyone help?thanks!Colum