hide / unhide columns

Hello! I am in need of a VBA that automatically runs if a user on my worksheet chooses a specific dropdown value. I would like Columns X and Y to automatically become visible only if a color code "Black" is selected from the dropdown in Column W. With all other values (Green, Blue, Purple...

Hello all, new to the forum but not to the site. Found many an answer or direction to start when dealing with my macros. So thanks for that. Unfortunately my current issue is above my skills and I can't find a forum that helps me find the answer, or I'm just not searching for it properly. I'm...

Hi, Can anyone help me with this ? I am currently using a macro that would hide all the column which sums to 0 including (A:E) which are text but i only want it to work from Column (F:MC). Please note that i have row headers on row 9 throughout these columns. Any help would be greatly...

I currently have a user form with many check boxes to hide/show columns based on if a check box is checked or not. Right now I have the code refer to the columns based on thier letter and everything works great. I would like to have the code refer to the name of the columns rather than the...

Hi, I have a question in regards to automatically hiding unused columns. I have several columns for each fiscal year, and have several fiscal years in my workbook. Is there any way to hide the columns fiscal years that are unused? Unused may be blank or with formulas but 0 value. Up to you...

Hi, I've got a quick question here. I have some data that looks like this %Pct Tag Tag Tag Note .5 SS .02 CS REVIEW .03 BY PARTIAL .9 .01 SL I'm looking to hide any column that doesn't...

Hi there, I am creating a simple grocery worksheet that has some instructions on it that I'd like to give users the options to hide/show. I made a button, created the macro, inserted it onto a module specifically for that button, and then tested it to see if it works. The first time I clicked...

Hello, I am trying to hide 150 columns using controlX checkbox but I can't seem to figure it out. At first, I tried doing this: Private Sub CheckBox3_Click() If CheckBox3 = True Then [E:F,I:M,t:Ai,am:ml].EntireColumn.Hidden = True Else: [E:F,I:M,t:Ai,am:ml].EntireColumn.Hidden =...

Hi there, I am struggling to figure out a way to show / hide columns based on whether the column header, which is a date, falls within the range specified elsewhere in the sheet. Example scenario below: Cell C4 (Start Date) contains a dropdown with a list of dates, say 05-Dec, 12-Dec, 19-Dec...

I am new to macros and VBA, so please type slowly. I am trying to use a checkbox (true/false) as a trigger element to call one of two Macros (Hide and Unhide a column). When false, I want the column hidden. When true, I want the column unhidden. I will need a total of 9 checkboxes and columns...

Hi There, I'm looking to hide columns AD, AF, AH & AJ on sheet DC Project if cell B13 from the Contacts sheet is equal to no or blank. If it is yes I want to show all of those columns. Can someone please help?? I can't figure out how to code it based on multiple sheets. This is what I have so...

<tbody> 1 down vote favorite I have a spreadsheet that there is a checkbox the purpose of the checkbox is to hide the name of clients in two adjacent columns. Because the spreadsheet changes from time to time the...

Hi, I have a task for my student project in front of me that I need to do.. I have looked in all kind of forums but unfortunately I had no chance finding the solution for my problem.. Being a absolute beginner in Excel I need someone to help me. I use Excel 2010 and I need to do next task.. I...

Hi, I have been trying to find an answer to this but can't find anything specific or that I can adapt to fit so hopefully someone will be able to help! My data looks like this: B C D E etc... 1 2 AP 3 AP KH TC 4 x x x 5 x...

Hope someone can help... I have a dropdown list of employee names to filter a matrix-style spreadsheet. On selection, all columns except the selected are hidden. My problem is that every time I add a new employee, I have to modify the code to match the name to a specific column. I need code...

Hi I am trying to write a simple macro to make repetitive task much easier. Issue I have is that when I run the Macro I cant use the filters or hide/ unhide features. I don't have this issue prior to running the Macro. The spread sheet itself if Password protected but I thought I had written...

Hi all, I have workbook that I would like to automatically hide/unhide rows & columns based on values. I have 3 activation cells on a worksheet called "Capacity Requirements". D7: The value of that cell can be 1-7 and is intended to determine the term of the model (from 2016-2022). In row...

Hello, I'm new to this forum and although i've been searching for days for a way to solve my question, I have been unable to do that so far, thus decided to create a new thread. So.. here is my dilema: I have to record the schedule of workers every month to proceed to payment accordingly...

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...