hide / unhide rows

Hi guys, I've been doing some googling and searching on this forum and I can't quite find the answer I need. So here's the situation: I have a spreadsheet of students in tutor groups (about 15 students). First worksheet is the summary sheet and gathers together data based on the data in the...

Hi, attempted to create a code to hide all "0" cell rows in a given column. These cells consist of a lookup seeking mail dates that have not occurred yet in data, so they are returning a 1/0/1900 value for the time being. Came up with the following code. I am not liking the run time on it and...

Dear all, I have a question regarding a spreadsheet I have. I have already searched other threads but I can't find any helpful solution (since it's quite complex). I do not know a lot about macro's and would need a macro to automatically hide rows if the row is empty (some rows do contain IF...

Hello! I am just getting started with VBA, and am trying to figure out two separate but related questions. I was hoping to set up a macro that would let me 1) Show columns where cell in row 2 equals values in 1 of 3 cells on a separate worksheet. So if the value in row 2 of current...

Hi, I'm new to VBA and Macros so apologies for that! What I have managed to achieve so far based on online forums and guides, is to hide or unhide a column and 'rows in a different sheet' based on a data validation selection in a cell. Example: <tbody> Stages Yes or No Stage 1 Yes Stage...

Hi guys, I'm trying to create a "front page" where a couple of checkboxes allow the user to unhide/hide rows in other sheets, based on the country value in the A column in these sheets. I've included my code for a single checkbox, which works well enough in terms of hiding rows when the...

I have been asked to create a check sheet where D16 is a drop-down data validation with 26 options, our of those options there are 6 options that do not require addition cells to updated and I would like to hide the rows that contain these calls. There are two instances of this type of scenario...

Hi, I have a file with the following VBA:</SPAN></SPAN> Private Sub Worksheet_Change(ByVal Target As Range)</SPAN></SPAN> Dim Sheet As Worksheet</SPAN></SPAN> 'I have a dropdown with the following options:</SPAN></SPAN> 'New > 250 but <750</SPAN></SPAN> 'New >750</SPAN></SPAN> 'Existing >250...

I'd like to hide column "B" for all worksheets and set the Row height to 15 for all worksheets when I open the workbook. I tried a For Next Loop but I'm encountering run-time errors. Here's the code: Sub Workbook_Open() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets...

Hi All, Please help with a VBA to hide / unhide rows based on named cell areas. I have a dropdown button with the following options: New > 250 but <750 New >750 Existing >250 but <750 Existing >750 Ending I have the following named areas: Pricing : rows 36-57 Customer : rows 62-65 Payment ...

I want to hide rows 9:11 if the answer to C8 is no, if the answer is yes, then unhide them. If nothing is written, then hidden. Does the name of the sheet matter?

Greetings, I'm new here and would like some assistance on VBA coding. I have a specific query which has defeated my lack of expertise. In one tab of a spreadsheet, I have a drop-down box (E19) with 5 possible answers, let's call them This, That, TheOther, Another, YetAnother. Based on the...

Hey anyone, I am having problems trying to work out a macro to hide/unhide a cell based on a value. The value is derived from a IF statement. Below is the information you may need, any help would be appreciated. I have looked through the forums and used other suggestions for other posts, but...

Hi, I am very new to macros and try to use them by visiting similar queries and trying out the suggested codes. But this one problem I am not able to solve. I am not sure whether this exact thing has been covered or not hence I am posting this. 1. So I have a set of values in a drop-down(from...

Hi, I am making a workbook for work. I'm using activeX checkbox to hide and unhide certain rows when a checkbox is activated. In the section of hidden rows I have another set of checkboxes. I got the code to hide and unhide them, but if I save the file with them hidden and reopen the file and...

Hi, I created a questionnaire on excel, with Activex check boxes. the checkboxes unhide the rows of the next question, depending on which one you answer. So I have hidden the checkboxes in the same rows as the question, using the 'move and size with cells' option. I set it up and it worked...

I want to hide certain rows based on a selection from a drop-down list. My code so far: Private Sub Worksheet_Change(ByVal Target As Range) If Cells(10, 8).Value = "Yes" Then 'ActiveSheet.Unprotect Rows("11:12").Hidden = False 'ActiveSheet.Protect , DrawingObjects:=True, Contents:=True...

Hi, I am looking for a macro to hide all rows that have the word "detail" in column B. This will ultimately be assigned to a button. I feel like this should be an easy one, but I seem unable to get the If function to work. Any help is appreciated.

Excel 2010: So I have VBA script that toggles between hiding and unhiding a set of rows. Private Sub CommandButton1_Click() Dim myRng As Range Dim myRng2 As Range Dim IsHidden As Boolean Set myRng = Me.Range("ProductionData") IsHidden = myRng(1).EntireRow.Hidden...

I have 2 Combo box's sitting side by side, based off the list I need rows hidden and shown, so that the proper questions are shown. This is repeated down the sheet. This is the code I was using when I was using Data Validation, however since I need the arrow on the right hand side to always...