VBA to Hide and Unhide Columns on Conditional Basis - Excel VBA Example

This Excel VBA Tutorials explains VBA code for columns Hide and Unhide. Also, how to Hide & Unhide Columns basis on conditions using VBA Macro.

[crystalmendoza]

I don't know anything about VBA and I needed to get a task done at work. After some trial and error (user error, of course!) I finally got it working. I would have never figured it out without this video, thank you!

[frankpartida]

Awesome example. Very detailed and easy to follow. Thank You...

[MohAboAbdo]

Thank you very much for this simple lesson and for this wonderful code

[mxrvxn]

This is a beginner friendly tutorial, easy to follow and well explained. Thank you so much

[jaswantdn]

Thank you so much, Sir. You have reduced half of my tensions.

[preethamsshetty]

Thanks for the Video. Explanations were great. What if the 3rd command was to automatically execute whenever there is "A" in Row 1 without clicking on the button

[fabianosilvadejesus]

Hello! Great video! I have a doubt. I would like to know if it is possible to perform the hide and unhide column action on the same macro button? For example, Click once hidden, click again unhide. Thank you very much for your attention.

[minion]

Hi, if don’t want to specify this macro to the current worksheet, how do we change the code?

[TheMengdong]

It is very helpful! Thank you very much!

[tarunmalhotra]

Hi I have a table In Excel wherein Column B have sheets name like 1 2 3 etc and Column C11:G40 has data validation conditions Yes or No. I wants to make Visible sheets if in Column C:G if its Yes and else if its No hide sheets. Can you help on writing this code.

[williambeehag]

Thanks very much for the video. I have a problem you may be able to help me with.

I have a tab which is formulated to produce a short sentence from data input on previous tabs. If select Yes then sentence is formed on comments page & if left blank then formula for the sentence returns a “FALSE” reading.

I would like to hide the rows that remain “FALSE” on my comments page through a button.

Are you please able to help me with this problem?

Much appreciated.

Bill

[kachachandresh]

i want blank rows hide in selected range how

[rajeevdixit]

I want unhide columns which are written part

[hemantkulharia]

need a solution want to hide rows but data is too large how to do it. Needs to hide the row as soon as we write down the word done in certain coloum for the same row ?

[nagadurgaande]

In manually we can give value but in automatically how can we give

[akio]

Thanks! Can I hide rows based on the name of the person who opens the sheet? I have one master file with 30 people who will enter their scores but i only want per person to see his assigned rows only.

[sanketnarkhede]

If I have to hide multiple columns using variable, how I can do it

[bijalagrawal]

I want to hide the columns or row, but when i want to unhide it, the password should come first, how can i do this ?