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!
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
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
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.
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 ?
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.
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.
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
It is very helpful! Thank you very much!
welcome
Very well explained .... thank you!
You are welcome!
Saved my life! Thanks a lot!!
Glad it helped!
awesome, thank you for this!
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
Super useful, Thanks
In manually we can give value but in automatically how can we give
more than great
Nice video
Thanks
Please provide me code for hiding specific column with colour
Hi, if don’t want to specify this macro to the current worksheet, how do we change the code?
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
I want unhide columns which are written part
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.
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
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
Thank you, it's a good video¡
How to hide tows
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?
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 :
ua-cam.com/video/AE3R5WGgdJc/v-deo.html
i want blank rows hide in selected range how