hide

Hello everybody, I've run into some problems with a worksheet that I'm doing during my internship. The idea is that based on the value of the cell CU2 I wan to hide rows with values greater than the cell value. So if CU2=3 I want to hide the rows 4-9 and so on. The easiset thing is probably to...

Hi everyone, I am trying to write a code that hides columns based off of a cell range. So if "Dog" is anywhere in B18 to B25, then columns N:X will disappear. Here is my code: Private Sub Worksheet_Change(ByVal Target As Range) If Range("B18:B25").Value = "Dog" Then...

Hi I'd like to hide a couple of columns in a sheet, if the columns are visible, without defining additional variables. I also don't want to use the Sheet name - I'd prefer to use the Sheet number that appears in the VBA editor. Let's assume the columns are D and M. And the Sheet is...

i am new and i need massive help please. please be generous as i am new. i am trying to create spreadsheet based on cell value with dropdown list (All,a,b,c,d) - if cell A1 = ALL range a5:j20 shows everthing (neither row or column hide). if A1="a" then row(s) and column(s) contain "a" hide...

afternoon all, i am new and i need massive help please. please be generous as i am new. i am trying to create spreadsheet based on cell value with dropdown list (All,a,b,c,d) - if cell A1 = ALL range a5:j20 shows everthing (neither row or column hide). if A1="a" then row(s) and column(s)...

Hi all, i would to provide me support so that, when i enter in cell "I4" the text "MONTHLY" should hide automatically the entire columns "D" and "E" and when i change the text to "YEARLY" should unhide the columns. Thank you all in advance

Hey! Wondering if I can get help. I'm using the below formula in a spreadsheet. I'm looking for it to update based on if I filter other parts of the table which would hide some of the rows between 2:999. Does anyone know how I can update my formula to ignore hidden rows...

Hello, I hope you all can help. I have a spreadsheet with dozens of sheets that contain pivot tables. It's based on a year's time with two columns for each month. One for Actual and one for Goal. Because of the way the pivot tables are set up, I need to have columns for each, but I only want...

This has just started to appear as the workbook loads. It continues to load and everything seems fine .. until I try to Hide or Unhide something. Some cols are ok and some bring up the error again. Is there anything I can do to fix it ?

Hi can anyone help with a macro that will hide rows one at time starting from the last row used on sheet2 ("A:Z). And a second macro to unhide the last rows one at a time. Then have this formula on sheet1("T5") count only visible cells on sheet2. =COUNTIF('Sheet2'!B:H,$S5) Any help would be...

Hi, Have code that hides the sheet tabs: ActiveWindow.DisplayWorkbookTabs = False Unfortunately, the User can change this via: Excel Options->Advanced, section Display. Is there anyway to prevent the user re-enabling the display of workbook tabs? In this instance Sheet.Visible =...

I created several PowerQuery but I want to hide it. Now, everyone clicking Data > Query and connection can find it. How to make it "invisible" to others ? Thanks

Im trying to auto filter out zeros on a sheet when a cell is updated. Is there a simple VBA that can do this? Also If a cell is blank, I want to hide certain rows on a separate sheet. is there another for this? Thank you

Hi, I'm trying to hide a command button if cell D8 does not equal 1, 2, 3 or 4. D8 is a dropdown, so changes manually. I have the following code below (which may or may not work) but I'm having difficulty including it with my other code (also below) as I keep getting errors. Can someone help me...

Is there a VBA or macro that can hide certain sheets when the save button is pressed? Thank you

Hi, This is my first post but I have found many answers on this website before but struggling to find something on the following problem: I am currently trying to write a VBA code which would automatically hide a whole row when this formula displays a blank =IFNA(VLOOKUP(A10,”Sheet...

Hi - I am working on a VBA to hide and unhide tabs in a single work book. I have a drop that consists of "Low", "Medium", "High", "Major". With the "Low" choice, I want to hide tabs "Key", "Stakeholder Interest Influence", "Stakeholder Mgmt Plan", "Risk Mgmt Plan", and "Quality Mgmt Plan"...

is there a way to once you put a sheet under Hide have it only viewable to admin users. or put a password on that sheet so one other then yourself or selected few can view it?

If i create a button, how can I make it hide a particular worksheet when clicked? and vice verse, a button that will unhide it

End goal: To enter a numeric value in a cell, and according to the value, it will hide all rows based on different values in a set column. Example: Enter 4 in cell B2 and it will hide all rows which contain values "AB5, AB6, AB7, AB8" in column P. What i've tried: VBA code, but i can only get...