hide columns

Hi Gurus, I was wondering if you know a way to click the header of a column (in row 2) and have Excel automatically hide all columns except for the whichever Column was clicked and also never hide Col-B? If clicked a 2nd time, I would like all to return to un-hidden as well. Thank you, RR :)

Hello- I have searched the forum, but have not been able to find this exact question. Found a bunch of related questions, but wasn't talented enough to translate them to solve my problem. =) I would like to conditionally autohide columns in response to a changes in the value of a single...

I have a .xlsx spreadsheet with 10 columns and 2 rows (A1:J10). If A1 is blank I want to hide columns A through J. If B1 is blank I want to hide columns B through J. If cell C1 is blank, I want to hide columns C through J etc. How do I write code such that once the columns are hidden, if the...

Here is my situation, I need to hide Columns based on Multiple Selected Criteria from Combo Box as follows: ComboBox is in A1, (ComboBox Contains 15 Counties from which I can select as many as needed). Every column contains one county name or multiple counties names in the same cell and across...

Hello everyone, I am pretty new to this whole Excel VBA, Macro business. I have a relatively large spreadsheet (couple hundred columns) and I am trying to make it easier to navigate / select what I am viewing. I am using Excel 2007 if that is important. This spreadsheet keeps track of contract...

I am having a problem with my macro, when I run it "A:H" and "O:T" Still end up hidden, I want them unhiden. Sub q2detail() ' ' q2detail Macro ' ' Columns("A:EQ").Select Selection.EntireColumn.Hidden = False Columns("A:H").Select Selection.EntireColumn.Hidden = False...

Hello there, i'm making an automated report file, and what i would like to do is hide specific collumns that have no value or come 0.(in order to not show on a graph) However the given month determines which collumns i do not want. So i wrote this: Private Sub Worksheet_Change(ByVal...

I have up to 18 columns of data. The first row contains a VLOOKUP formula which returns a blank, 0, 1, 2, 3 etc up to 18. If there are only, say, 10 columns that I want to be visible, they will be numbered 1 - 10 and the other 8 columns will have either a blank or a 0 in the first row. What...

I am somewhat a novice with VBA, in other words, I am still learning. I am trying to write a vba macro that would hide columns based on what is presented in another table. This will allow me to update the table and not have to worry about updating the macro on a continuing basis. For...

Good Afternoon All I've found this code on the tin-ter-web and it works Private Sub Worksheet_Calculate() Application.ScreenUpdating = False Dim c As Range For Each c In Range("K8:CD8") c.EntireColumn.Hidden = (c.Value = 0) Next c Application.ScreenUpdating = True End Sub...

I have searched the forum related to hiding & unhiding ranges, but none of the code examples/solutions have done the trick for me! I want to be able to unhide a column in multiple sheets with the click of a button. I then have a second button which will hide these columns. Here is my code...

I have a large, (78 sheets and a high level of vba automation), well established Excel2003 spreadsheet that iI am now trying to run in Excel2007. I have a problem with one sheet where there are 8 additional rows displayed below the ribbon but above the standard column headings! Three of these...

Hi all. This may be around somewhere in the forums, but I appear to be searching incorrect key words. I have a range of columns (I:AQ) that a user can freely use to enter quantitative data. Each column represents a province of Vietnam. Column AR contains qualitative data (comments) that...

I have a worksheet that includes user input regarding the number of months required for the cash flow. I want the cash flow spreadsheet to automatically adjust (contract/expand) the number of columns pertaining to the number of months in the cash flow (the months are listed on the top of the...

Hello all, I am using Excel 2007 in Windows 7. My issue is that I need columns to automatically hide themselves without having to Alt+F8 and running the program. My data set is: <table style="border-collapse: collapse; width: 336pt;" border="0" cellpadding="0" cellspacing="0" width="448"><col...

Hi there - thanks for your time in advance. :) I am trying to create a report from excel that does the following: i have my checkboxes in sheet 1, and i want to hide various columns if the checkbox is not selected in sheet 2. each checkbox is directly related to a column in sheet 2. example...

Hi, Can somebody tell me what is wrong with the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("WK05_TRUE_FALSE").Value = False Then Range("AI:AL").Selection.EntireColumn.Hidden = True Else Range("AI:AL").Selection.EntireColumn.Hidden = False End If End...

Hi, I have tried to put together some VBA code to hide columns on several sheets, using answers based on various responses but have difficulty because my sheet names may vary, as some ships call Accommodation - House Keeping, and Garbage - Incinerator. To cope with these name requirements...

Hi, all As a VBA incompetent, I'm butting up against problems that I can see a logical solution to, but that I have no idea how to code, and I would very much appreciate assistance if possible. I have an activeX combo-box that selects from different pieces of equipment that we supply. Based on...