hide

Hello Everyone In A1 i have a path d\temp\action.xlsm Action.xlsm Workbook has a worksheet by the name of secret Right now in current open active workbook.. name sample.xlsm. i have a button. I want if i click on that button action.xslm worksheet would be hide. In simple i want to hide...

I need to hide all columns beyond column Z using VBA

If you a have sheet that is filtered, and hide columns, then sort (via any viewable column), does the hidden columns also sort? I have a fairly sizable file (12k rows, 37 cols; several columns are for me) that I want to send to a few team members to sort/verify/update their data. I'm...

Hi, I am not sure if i am close but i am attempting to hide a range of rows based on the value of another cell. To be more clear A11 value is "Status" and i need to evaluate B11 and if it is "Open" then hide 11 rows up. This repeats in a dynamically lengthed document that i run weekly...

I found this - - Worksheets(“Sheet1”).Range(“RowNumber1:RowNumber2”).EntireRow.Hidden = True - - and would work, but would have to modify it each time based on the worksheet I'm in. Yes, right-clicking is easy, but when there are hundreds or, and a couple of times, thousands, no so much. Is it...

Hey everyone, I am using the following code to hide rows in a workbook where column A has the value "Hide". However going through 500 lines seems to take a long time. I am wondering if there is a better way to have excel search and select all rows where the value of column A is "Hide" and...

I have a sheet with a list of customer orders called (FTBJOB2) the data is contained in cells A to AP of the table starting from row 13 I Know how to make a combo box that places whatever is typed, in a specific cell. In this case it will put the result in cell ("AQ12") I would love a code...

No doubt this has been covered before is there a VBA to hide the headings in all worksheets Thanks everyone Regards Jason Bing

I have the bellow code Range(ActiveCell.Offset(0, -11), ActiveCell.Offset(0, -20)).Select I need to hide entire colums that contains selected cells

Hello everyone, I have a workbook that needs to hide columns if a cell value is less than 0 and, as something entirely separate, hide numerous rows if nothing is displayed in them. Both of these will be pulling their conditional cells from cells with formulas in them. For example, the macro...

I’m new to macros and am NOT a programmer. I can use the “Record Macro” function and assign to option buttons to either hide or unhide pretty easily, but I’m struggling to get it to do what I want. I am trying to create a series of yes/no questions where the answer to the first question...

I have the follow script in vba: Sub ConditionalHide() Dim cRange As String cRange = Sheets(1).Range("H3") For i = 2 To Sheets.Count Sheets(i).Activate If Range("H3").Value <> cRange Then Sheets(i).Visible = False Else: Sheets(i).Visible = True End If Next i End Sub The problem is that it...

I am hoping to create a way to hide rows on multiple sheets based off the text in the currently highlighted cell. So, for instance if I am on Sheet 1 and I am highlighting a cell containing "John Smith", I want to hit a button (from developer inserts) and it will hide all rows (across all 5...

Hi, Using below code to hide rows based on column A if the value does not equal 1 Sub hide() Range("A1", Range("A" & Rows.Count).End(xlUp)).AutoFilter 1, "1", , , 0 End Sub Is there a way I can use this code to hide some columns ? Any help would be appreciated Regards, Humayun

Hello everyone, I specifically made an account so I can figure out how to do this in Excel. So what Im trying to do is hide the rows when cells from a range of columns does not have data in it. Example: K4:Q4 will be filled in with data and if theres no data on this entire column then I...

Hi, I want my excel to hide and unhide a row when i select an option from my drop-down list but it is not working. My excel sheet needs to be protected and certain areas need to be locked including part of the row. Here is the code: Private Sub Worksheet_Change(ByVal Target As Range) If...

I have a column (A) that has below values in different cells (A1, A2 and A3 and so on). PPC Revenue - 2015 Non-PPC Revenue - 2015 ROAS - <Enter PPC 1 Name> - 2015 ROAS - <Enter PPC 1 Name> - 2017 Non-PPC Revenue - 2016 Non-PPC Revenue - 2020 I need a macro that can be used to hide/ unhide...

Hi - relatively new to VBA and needassistance! I have a list of around 50 cell values that sum up columns in correspondingsheets in the same workbook, I would like to hide the particular sheet based onthe value of the cell. In the example below I would like to hide sheet 1 only, but should the...

I have dates in column C from row 8 and would like to have a macro which on accessing the sheet would hide all rows where the month and year of the date in column C is less than the now. So as at today I would only want to see rows from July onwards. As ever my thanks for any assistance

Hello All: I have a workbook that has a tab named "Log". The workbook also has many other tabs as well. In the "Log" worksheet, range A3:A200 contains tabs names. Range D3:D200 contains either "Yes" or "No" or "...". I would like to add VBA to hide tabs where (for example) if D3 contains...