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...
View 12 Replies
ADVERTISEMENT
Dec 23, 2009
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.
View 9 Replies
View Related
Feb 3, 2012
Using Excel 2007.
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
View 1 Replies
View Related
Nov 4, 2008
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:
View 4 Replies
View Related
Sep 29, 2013
I have 10 activex labels. How do I make all 10 labels visible/invisible in vba coding?
Instead of typing label1.visible = true, label2.visible = true and so on.
View 8 Replies
View Related
Jul 30, 2006
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?
View 9 Replies
View Related
Jul 26, 2013
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.
View 5 Replies
View Related
Mar 26, 2008
Is there a way to make the last two digits in a number not show up (make them white) and also cut off the last two digits?
View 9 Replies
View Related
Jun 5, 2014
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
View 11 Replies
View Related
Aug 30, 2013
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.
View 4 Replies
View Related
Dec 30, 2009
I designed my spreadsheet incorrect.
Everything works good. But when I selecting tables with listbox, I forgot to notice that there also comboboxes.
I mean, rwgrietveld, I use selecting table to hide 'em, but when I hide 'em comboxes should also disappear (become invisible).
is it possible at all to make invisible activex commandbutton in selection?
View 11 Replies
View Related
Apr 22, 2009
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.
View 3 Replies
View Related
Mar 2, 2014
I have sheet1 and have textbox5
I want it to be visible if Range J17=25 or else it remains hidden.
I am trying this way but it will not work.
View 10 Replies
View Related
Jan 10, 2008
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?
View 4 Replies
View Related
May 12, 2013
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?
View 2 Replies
View Related
Aug 3, 2006
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.
View 9 Replies
View Related
Nov 21, 2006
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!.
View 9 Replies
View Related
Apr 12, 2012
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.
View 1 Replies
View Related
Jul 6, 2013
I have a user form with multipage.
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.
View 5 Replies
View Related
Mar 9, 2009
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?
View 7 Replies
View Related
Nov 27, 2012
Is there way to do this? I did not find it.
View 5 Replies
View Related
Jan 4, 2008
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
View 9 Replies
View Related
Jun 17, 2009
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.
View 4 Replies
View Related
May 28, 2012
Starting from D6 to the end of the data (could be F6 or AA6) I need to sum the total, but only if the column is visible.
View 9 Replies
View Related
May 8, 2013
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
View 2 Replies
View Related
May 9, 2008
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
View 3 Replies
View Related
May 6, 2014
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.
View 8 Replies
View Related
Dec 1, 2009
I have filtered a worksheet and want to only total the data in the columns that are visable, is this possible?
View 4 Replies
View Related
Jun 4, 2007
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"
View 9 Replies
View Related
Feb 5, 2008
I am trying to write the contents of a worksheet to a notepad file. Also, the worksheet has some hidden columns.
View 9 Replies
View Related
