VBA to Hide and Unhide Columns on Conditional Basis - Excel VBA Example
HTML-код
- Опубликовано: 11 сен 2024
- This Excel VBA Tutorials explains VBA code for columns Hide and Unhide. Also, how to Hide & Unhide Columns basis on conditions using VBA Macro.
U just finished my task.
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!
Great Job! if you need any assistance in VBA, you can write to exceldestination@gmail.com
This is a beginner friendly tutorial, easy to follow and well explained. Thank you so much
You're very welcome!
Thank you so much, Sir. You have reduced half of my tensions.
Excellent
Awesome example. Very detailed and easy to follow. Thank You...
Thank you very much for this simple lesson and for this wonderful code
Saved my life! Thanks a lot!!
Glad it helped!
It is very helpful! Thank you very much!
welcome
awesome, thank you for this!
Very well explained .... thank you!
You are welcome!
Super useful, Thanks
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
Nice video
Thanks
more than great
Hi, if don’t want to specify this macro to the current worksheet, how do we change the code?
Thank you, it's a good video¡
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
Anybody able to help with this question? Would be much appreciated
In manually we can give value but in automatically how can we give
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 ?
I can provide the customized code, that will do your task. Send me email at exceldestination@gmail.com
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.
yes, absolutely. But, for that you would be required to write additional code.
@@ExcelDestination thanks. Can u share the starting point?
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.
I want unhide columns which are written part
If I have to hide multiple columns using variable, how I can do it
some additional code would be required.
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 ?
You can take some help from another tutorial for using password through VBA. Link is :
ruclips.net/video/AE3R5WGgdJc/видео.html
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.
Yes, with and ActiveX toggle button
How to hide tows
i want blank rows hide in selected range how