hide / unhide

Hi, I'm trying to find a macro code to hide/unhide certain/selected cells only using the checkbox. For example, if I tick the checkbox, it will show cells "A4:D9" but when I unchecked it, the mentioned cells will be hidden. Attached is a sample of my query. The shaded parts are the ones...

Hello all, Firstly I’m not that good in English so I’m sorry if my grammar is hard to understand. my macro can get unique value in column “D” and split to each workbook by copy row that unique value was (example : in column D at row 1,5,7 is got same data so my macro will copy and place at new...

Hi there, Hoping someone can help me with the following: I have a yes or no dropdown in cell J13 and would like to hide row 14 if the value in j13 is no. If the value in j13 is yes, I would like row 14 to unhide. I would like to run the code each time the value in J13 is changed. Any...

There is a drop down list from D to AG in VBA user form. The user selects any column from D to AG in the form. I am looking for a simple VBA code to show exactly one column from D to AG (which user have selected) and hide all columns between D to AG. All other columns (not in between D and AG)...

Hello, I am very new to VBA and looking for help hiding rows if the the first cell (Column A) in the row (7-72) is zero. I would also like to unhide the rows if the cell is not zero and ideally not have to manually run the code each time the values in column A change. Column A is dependent on...

Hi Please some one help me to find the solution for the below question? I have 2 sheets called Buttons and Database as shown in the below image. Upon button selection I would like to show only selected Name/Skills in Database sheet. eg: If "Dinesh" button selected show only Dinesh rows in...

Hello, I have added some clickable buttons in few cells, but when I try to hide a row, the button still remains. Is it possible for the button to be hidden together with the row? I thought that might be the solution but I cant even choose the first one. Also, is it possible to make the...

Hi, I have put together this code to hide all blank cells in certain Row ranges across an array of worksheets. It works ok, but it seems to take some time to complete and uses alot of computer resources to run. Is it possible to use alternative VBA code to be more efficient and speed up the...

Hi guys, i really need help. I want to make a program where if i pressed the button once: The cell 1 from example (B:2) will hide and if i pressed the button twice: The cell 2 from example (B:3) will hide and so on and so forth until 5 clicked. Thank you for the help.!

I just started working on compiling all of the sub contractors and material vendors we have with pricing. What I would like to do is give each contractor their own work sheet page so I can keep up with pricing changes year to year. This will create a lot of worksheets in one work book. Would it...

Hi guys, I have some questions about hiding and unhiding buttons. Here comes my code, and I rename the button "Cal" and the error is that "Object doesn't support this property or method" here is my code Sub ClearForm() Dim ReportSheet As Worksheet Set ReportSheet =...

For this example we have 3 agents (Agent 1, Agent 2, Agent 3) listed drop-down menu. When their name is selected from the drop-down the monthly table (the green one) will auto populate their info. Below this there are 3 additional tables: One for each Agent showing their stats month by month. I...