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
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.
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 ?
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
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.
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.
You can take some help from another tutorial for using password through VBA. Link is : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AE3R5WGgdJc.html