Make Columns Visible/invisible As Per The Conditions
Sep 4, 2009
I am trying to create a daily task activity sheet. I would like to know, how to make the columns visible and invisible as per the selection from previous column.
For eg:
Column A has a list which has values 'TC creation' , 'TC modification', 'System Test' etc.
Upon selecting TC creation, i need to make a column visible ie 'total tcs created'.
Upon selecting 'TC modification' i would have to make the previous column invisible and make a new column visible for entering no of tcs modified.
Upon selecting 'System test' the other columns should go invisible and make other 3 columns visible for no of tcs executed, no of tcs passed, no of tcs failed etc...
I have put calendar in my form and I want it to be visible only if I click on the combobox and make it invisible when date gets filled in the combobox.
I wrote the following code but it gives me runtime error -2147417848(80010108) Automation error :The object invoked has disconnected from its clients.
I have some connector lines that cross over tables in Columns G:K that are connecting tables in $D to tables in $M
How can I make the part of the connector line in $G:$K invisible?
something like:
Code: Sub FormatConnector Dim oConnector as Shape With oConnector If .Connector Or .Type = msoLine If .Connector In Columns($G:$K) Then .Connector.Segment.Visible = False End If End If End with End sub
I'm using the following code, which I figured out quite by accident out of happy coincidence that somebody else on here asked about selecting only visible rows:
I have several buttons I and a chart I want to make invisible and visible programatically. The buttons have names like Button65, etc. I did not give them these names. Curiously, these buttons don't have properties when I right click on them in design mode as do other objects. Why not? Further, they act more like rectangles drawn from autoshapes in that I can assign a macro to them, but unlike a rectange they are not named as rectangles (e.g. rectangle 284). Why not? These are hybrid creatures!!
I like to use rectangles as command buttons, but then they do not have properties which allow them to be made invisible, etc...
The chart name is Chart 1. Same problem, it has no properties. How can I make it invisible?
I have an excel sheet that lists a bunch of different recipes. Right now I have all the recipes saved in individual sheets. Each of these are hidden when the sheet is opened. I have a main sheet which lists all of the recipes names and when clicked, the specific sheet opens up. What I am looking for is a code that will hide all of the sheets except for the sheet "Sortable List" and "Detailed Lists". Each of the buttons I have which open up the recipe sheet look like this:
VB: Sub Banana_Split() Sheets("Banana Split").Visible = True Sheets("Banana Split").Select End Sub
See I think the user might click on a bunch of the names to see the recipes and then get overwhelmed with there being so many open sheets.
I'm trying to create an accounting document, but stuck in couple fields
1) Make balance appear in column E5 only if column C5 OR D5 is polulated, so goes for the rest of the cell in that colu
2) I like to have 2 digits after the decimal but (same as above) i want it to appear ONLY if there are any decimals to that number, all those 0 become confusing.
3) I need to make it so the last calculated cell on sheet Jan of column E gets transfered auto to sheet Feb D3 of F3 so the calculations could proceed to the next month
I wanted to know if I can make an error message invisible or maybe have the text white so you can't see it. For example, Iam using the vlookup formula which works fine when it is reading right. But when there is no info in the cell I'm looking up I get a #N/A. So I would like to have this sheet set up so that when you enter someone's name it gives you address, cell, etc.... But if no name is entered, instead of showing #N/A in all the cells.....I would like it to just look like an empty cell. I'm thinking I can use conditioning formatting so that if there is an error message then the text color is white. Can't quite get it to work.
Need to correct code to resize all visible rows on a sheet based only on the text in the visible columns. I have tried the below code but when it resizes it is using the largest amount of text in the rows including that in the hidden columns.
I have a workbook that was opened with a Word macro but was mistakenly not made visible. I didnot realize the workbook was open because I didn't see it. I tried to open it manually and found that it was locked for editing because it was already open due to the Word macro opening it. How do I close it?
Is it possible to have those small drop-down boxes that appear when typing in the function parameters (using Enum), to also appear with ParamArray parameters as well?
I would like to loop through my workbook and distinguish (somehow) all of the cells that are named. I would like to do something to them so that I can easily glance through my workbook and find all ranges that aren't named. My biggest problem is that I would like whatever distinguishing I do to be reversable. Therefore, I can't just make all of the backgrounds of named ranges bright yellow, because then I would lose the original background color of my cells (they aren't all white).
The best option that I have thought of so far is inverting the fill color of each cell (this would be reversible). However, I'm not sure how to invert colors.
By the way, if the named ranges could be distinguished in some other way than by using background color, that would be fine too, as long as the changes are reversible.
I have the following situation where "#value" appear and I want to make it invisible, is there an easy way to do this ?
A1 0 C1 0 D1 0 G1 = A1+C1+D1 A1, C1 or D1 is the if statement cell where evaluated value may be zero. If the evaluated value is zero, then G1= #Value!.
I have a boolean toggle for disabling and enabling a Workbook_Change event.
Right I invoke macros to turn the Workbook_Change event on and off and I don't know what state it's in.
Two Questions: 1) (required) I would love to be able to visually know if it's enabled no matter which sheet I am on 2) (bonus) Be able to change the state with a persistent interface (e.g. perhaps the Ribbon?) no matter which sheet I am on.
With the use of the option buttons,the page needs to made visible or invisible.
Example: on Page one, i have placed radio buttons as page2,Page3&page4.
By default only page 1 should be visible and when we select radio button page2, page2 should become visible or else it should be invisible,when we select radio button page3, page3 should become visible or else should remain invisible.
I am using Excel to tabulate votes for a contest. Judges have given a number to each entry, and but certain judges' opinions need to count twice as much as other judges' opinions based on their qualifications.
I've attached the file to help illustrate what I'm trying to do. Morris's votes need to count twice for all Photography or Web Design entries, and Clark's votes need to count twice for all Graphic Design or Web Design entries.
I know I can do this manually by simply copying the number into a blank cell in another column (like the blank column between Morris and Clark's names), but is there any way to make Excel do this for me?
I have a worksheet that has several hidden columns and wish to have the EntireRow.Autofit apply to all rows in the current region based on visible columns. After using the WrapText method on all visible cells, one of the hidden columns with a lot of characters causes the entire row to be much larger than desired. Is there a way to use EntireRow.Autofit to only expand the height of each row in the current region as necessary based only on the visible cell contents in that row?
Set AllCells = ActiveCell.CurrentRegion ActiveCell.CurrentRegion.Select With AllCells .Font.Size = 6 .Font.Bold = False .WrapText = True .EntireRow.AutoFit = True End With
I do hav a sheet in which i do hav some column;s n data
Worktype Metrics April May June
in work type few rows are hidden which i don't need what i need is i want to populate only comman metrics in other range named metrics i had build a macro for this and that's working fine but the problem is it also reads metrics from hidden rows too. i had tried a loop in which i had placed as hidden column property condition.
I am looking for a bit of code that will count the number of visible columns either. I have the following which is missing the code to establish if the range is visible or
Code: Do Until rngVisibleColumnCount.Column = Range("HRISData_RoleError").Column 'Code to establish if visible intVisibleColumnCount = intVisibleColumnCount + 1 Set rngVisibleColumnCount = rngVisibleColumnCount.Offset(0, 1) Loop
In the code below, I found out how to make the column widths automatically adjust on a worksheet based on the text entered. This code works great but it also reveals the hidden columns on the worksheet. Can i prevent it from doing that?
Private Sub Worksheet_Change(ByVal Target As Range) With Me.Cells .Columns.AutoFit End With End Sub
Found here: Automatically Adjust Row Height & Column Width
I need a macro to start at cell A11 and select across 10 columns and down to the Lastrow (last row with any data).
There are hidden columns after column D so it CANNOT have any columns hardcoded except for column A.
This selection then needs to be set as a single print area to print out on 1 page. I have already set Rows 1-10 as a title area to print at the top of each page.
Code i currently have is:
[Code] .......
I just need it to now go across 10 visible columns and set as a single print area.
I have an Excel sheet with all client information...For clinical supervision I want my team members to open their own "Supervision.xls" and click a button...this button will open "Client.xls" and select "Client info sheet"...It will then hide rows c,d,g & f...it will then filter column "e" based on the specific caseworkers name ( say "Joe") and copy only the visable columns back to their "supervision.xls" Values only (doesn't effect the colour formating of Supervision.xls) then close "Client.xls"
