hide / unhide columns

I have two sheets, "Operation" and "EHSQ", I want to be able to hide and unhide certain columns on these sheets, I am thinking of using a a shape and assign the macro where the user can press, like Q1, Q2, Q3 etc. So the user hits Q1, if the columns are unhidden, then the macro hides it and vice...

Hi everyone, I haven’t used excel in many years, so am more than a bit rusty. I have the following code to hide Column P if cell A1 contains the value “Text 1”. I am trying to add additional arguments so if A1 equals “Text 2”, it will hide Column T or if A1 equals “Text 3” it will hide Column C...

Hello, I have an excel file. I want to automatically hide the corresponding columns during opening. How can this be done? P.S. With the help of Python, I automatically open Excel and take a picture. When opening, I want it to be hidden if cell = 0, or visible if cell = 1.

Hi currently, i want to hide column in my excel based on their column header. This is the code i came out but it keep hit error at line Cells(1,col).entirecolumn.hidden . It hit error hidden method of range class failed Dim col as long, lastcol as long , header as string lastcol =...

Hello everyone - I did find a thread that I think is close to what I'm looking for - but I'm having trouble translating it to look beyond one row's worth of conditionals. Basically I have a list of properties in the columns for a full set of product categories, and based off a selection in a...

I have much the same question as but can't get the answers to work Columns J1-N1 have headers 1 2 3 4 5 I want to hide columns based on S1, which takes values 1-5 If S1 = 1 Hide columns headed 2-5 i.e. K:N If S1 = 2 Hide columns headed 3-5 i.e.L:N If S1 = 3 Hide columns headed 4-5 i.e.M:N If S1...

Dear Forum, I have this code in Excel VBA: Sub Outlook_Mail_Every_Worksheet_Body() Dim OutApp As Object Dim OutMail As Object Dim ws As Worksheet With Application .EnableEvents = False .ScreenUpdating = False End With Set OutApp =...

i have this toggle button code that hides and unhides for me column E and D but now i want to also hide column P at the same time with them but without hididing the columns between them i just want to hide E,D,P i use this code but i’m writing this on my phone but just to get an idea private...

Hello all, I have some table build up from different formulas and so on. Final result is some huge sheet filled with columns and lots of rows showing just True or False. I'd like to know how i could hide all columns that are all their values True, so i can just end up with just the False...

I am BRAND NEW to VBA coding and have tried to figure out how to write what should be a simple code with zero success. I'd like to attach the workbook, but I don't have privileges in this forum. Summary of goal: I have one tab called "Instructions TM1" and another tab called "Ops and ADS...

Hey, I've been having issues trying to set this up so was hoping someone could let me know how badly I'm messing up. 　 I have on sheet one, B15, a drop box that shows from: - "Single" - "Multi x2" - "Multi x3" etc until x10 　 and on another sheet, information that fills in the C column if x2 is...

Long story short, I have specific columns on the right side of my worksheet that will 'show' or 'hide' depending on input from the left side of the worksheet. If it was just me, I would do this manually and not bat an eye, but I give this worksheet to a bunch of people who think the only way to...

Good day guys & Happy New Year! I have an excel sheet with little bit of VBA code from it to hide and unhide columns https://drive.google.com/open?id=1phpOXBmhJ35_ptgYHCQPhkRkft2APTtl. The sheet works properly but when I added another column some days of the month was hidden too. Like for...

I have 3 tabs within my workbook that I would like to hide columns based on cell value. The following code hides some of the columns, but I am looking for assistance to add the rest of the columns. Here is what I am looking for: Hide Columns J:M if cell K18 is "" Hide Columns N:Q if cell O18...

Hey guys, This is my first time posting, but I've definitely used the forums for help before. I need to expand and collapse columns based off of the numerical value in cell A1. And I need to use VBA to do so. Columns B:Z will expand and collapse. For ex. A1 = 0 then no columns show. A1=10 then...

Hello I have limited knowledge with macros so would appreciate any advice you can give me. I have a Workbook that has several users - most only need to view the Workbook, others need to edit certain columns. I would the columns that need to be edited hidden on opening and only visible once...

In my Worksheet2, the data are generated based on formulas that reference to data in Worksheet1, and are formatted as a list (from A1 to AS100) like below: <tbody> A B C D E F ... AS 1 ID Code Property1 Property2 Property3 Property4 ... Property28 2 1 AAA 111 3 4 3 CCC...

Thanks for looking at my post. I have the code below for hiding a column in my workbook. I was wanting to see if the code could be made so it would hide column A on any sheet. I have 21 sheets in the workbook Sub Hide_Column() ActiveSheet.Unprotect If...

Dear Excel Experts I adapted a conditional formatting Macro for my purposes. It works now with an inputbox quite neatly and highlights the cells where the keyword is found. However, I want to hide the other rows where the keyword isn't in. I don't know if that's even possible with this code...

So I'm missing something simple but I just can't see it. I'm using .Find to search cells in a range("J6:BFA6") dim'd as "Name" for a user entered word from range("E5") dim'd as "NameS". If the value isn't found, the column becomes hidden, if it's found the column unhides. It hides the columns...