Hide Column After Grouping/Outlining

Mar 6, 2009

When my user clicks a Group by button in Excel (+)(-), I want that event to kick off a macro that will hide columns D and E.

The idea is that when the user views data at different levels of aggregation, the spreadsheet will 'de-clutter' itself by hiding columns that the user doesnt need to see.

There is no obvious Excel event that responds to Group By. Can a Class Module achieve this? If so, can someone give me a 30 second overview?

View 3 Replies


ADVERTISEMENT

Outlining Does Not Work On Protected Sheet

Feb 3, 2014

I am using Outlining on a sheet called "Today".The sheet is manually protected but now the outlining does not work as it says sheet protected.Is there a code i can use so that i can still have the Outlining working in a protected sheet.

View 5 Replies View Related

Enable Outlining In A Shared/protected Workbook

Apr 22, 2009

I would like to know how the following code provided in the Excel Help Best Practice Forums , used to enable outlining on a protected sheet, can be applied to a shared workbook.

Private Sub Workbook_Open()
With Sheet1
.Protect Password:="Secret", UserInterfaceOnly:=True
.EnableOutlining = True
End With
End Sub

After enabling 'Share Workbook' and re-opening the file it presents the following error:

Run-time error '1004': Method 'Protect' of object '_Worksheet' failed

View 2 Replies View Related

Grouping Same Values By A Number Sequence For A Column

Mar 13, 2013

I am trying to group the same values in columns together and i was thinking about having a number count. What's the function that might be able to display this (display whats in Column B in the example below)?

Values
5000 1
5000 1
6000 2
7000 3
7000 3
8000 4
8000 4
8000 4
9000 8
10000 9
10000 9

View 1 Replies View Related

VBA Macro Code For Grouping Based On Column A

May 1, 2014

i need to group the values based on A, B, C columns.

which means all "Chickpea_B-1_11area_3d.csv " will have same timestamp and mean_area_3d values, only D column vlaue changes.....

in the same way, all "Chickpea_B-1_12area_3d.csv" will have same timestamp and mean_area_3d values, only D column vlaue changes.....

now i need all Chickpea_B-1_11area_3d.csv values to be grouped into one. and chickpea_B-1_12area_3d.csv values to be grouped into one..

if you see the output sheet, you will understand clearly, which i did manually for your easy understanding...

i did manually and also attached the sheet for your kind reference and easy understanding... where i grouped all Chickpea_B-1_11_area_3daver_domain_area, fill_factor, leaf_angle_theta, plantHeight, projected_leaf_a into one.... where b and c cols are same for all the D E F G H I Values. in the same way for Chickpea_B-1_12_area_3d and all other below values to be grouped.

like this i have to do for 1000 files. please find the attachment...

View 12 Replies View Related

Crosstab Query Grouping By More Than One Field/column

Apr 19, 2009

In access you can create a crosstab query grouping by more than one field/column and totaling on more than 1 field/column

ie Goup by Acc No then Cost Centre
Sum on costs by date -up to 31

View 9 Replies View Related

Query Hide State Of Column Ranger And Hide If False

Jun 18, 2009

I want to create a macro that checks whether a specified range of columns is hidden, and

a) hide them if they are not hidden, or
b) unhide them if they are hidden,

i.e. toggle the Hide state.

What method can I use to query the hidden state of a selected range of columns and return a boolean value?

View 2 Replies View Related

Vlookup Using 2 Condition One Based On Devices And Grouping Column?

May 27, 2014

Attach below are 2 sample file and inside it consist of device,grouping and lb1,tb1,ab1. How do I use excel formulae based on 2 condition and set from vlookup with 2 condition file to vlookup with 2 condition 1 file like a vlookup.

View 11 Replies View Related

Hide Column(s) But Still Have Data In That Column Be Visible At Bottom Of Spreadsheet

Jun 23, 2014

I was wondering if it is possible to hide a column(s) but still have data in that column be visible at the bottom of the spreadsheet. For example, if I hide column G can it only hide the column from rows 1 - 50 and then the column will appear after row 50?

View 3 Replies View Related

How To Hide Column After Select Other Specific Column

May 27, 2014

In the attachment is a file, which allows me to specific a Column and hide. For Example enter "H" in the InputBox and Submit the Column "H" is hide.

What do i have to change in the code if i want to hide the "H" and the Column two columns next to "H". In this case "J".

HideColumn.xlsm

View 3 Replies View Related

Hide Column Based On Cell Value For That Column

Jul 4, 2012

I have a Worksheet were I have a formula in cells from D5 to ALO5. That read "Hide" or "Unhide".

I would like the column to each hide individually hide if that column has "Hide" in in it. If it has "Unhide" in the column then it becomes visible again. The range of the columns match the formula cells which are "D" through "ALO".

View 1 Replies View Related

Hide Last Row In Column

Jun 16, 2008

I have a macro that hides row A80 (a grand total for adding numbers). But, if I were to insert, or delete a row, my macro continues to work, but no longer reflects the appropriate row "grand total" row and hides a blank one because of this shift. Can I somehow freeze a row in my macro so regardless of what is altered in previous rows, my macro will always hide my grand total row?

View 6 Replies View Related

Hide Row When Zero Values In Column

Jan 15, 2014

I have a Pivot table and would like to know how I can hide a row where there are zero values in Col D in my Pivot table.

View 6 Replies View Related

Hide 0 When Column A Is Empty

May 2, 2014

I need a formula, or a filter (or something?) to hide zeros in a column, but only when the corresponding cell in column A is empty.

View 11 Replies View Related

Hide Column Based On A Value

Jul 6, 2014

Is there any formula to hide a column based on a value . I know we can do that manually using hide and Unhide option.
but I want this to be done dynamically without A MACRO.

In the attached sample spreadsheet, the row 3 (status) has either 0 or 1 that is feed from another sheet and change dynamically. I need to hide all columns with a value 0. In this sample columns B,D,H,I,J,N & P must be hidden.Suppose If the staus value is changed from 0 to 1 then the column must be displayed (unhide).

View 1 Replies View Related

Hide The Column Macro

Sep 9, 2008

I'm not a VB programmer and have tried to write this macro but I can't seem to understand why it's not working.

View 11 Replies View Related

Hide Column If Empty After Row 3

Sep 7, 2009

I have more than 50 different sheets with columns A to AA where i would like to hide all empty columns. If for example column K is empty auto hide column K. I also have rows 1, 2 & 3 which have headers which need to be ignored when checking the columns.

View 12 Replies View Related

Hide The Cell In Column

Jun 24, 2009

1. I have Column I, K, L which contain Values (no formulas/references)
2. I need each cell in those column to divide each value by corresponding # in column H. For example I2=10, macro needs to turn I2 = 10/H2. Then everything needs to be formated to 3 decimals. And I need the same to happen for each Cell in Column I, K, L. At the end those columns need to be hidden.

Here is the code that was written before (i'm getting an error in highlighted part):

Dim MyRange As Range, NewFormaula As String, Delim As Range
Dim Cell As Range
Dim MyString As String
Dim Format As Range
Dim ws As Worksheet

Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Delim = "@"
For Each ws In Worksheets
Select Case ws.Name
Case "PBDay locks", "Total Locked Pipeline"
Set MyRange = ws.Range("I:I")........................

View 9 Replies View Related

Hide Column If Cell NOT A Certain Value

Aug 26, 2006

The following code hides all columns in my worksheet from AG:IV if the value in row 37 is "Attendance". I really need the flip side of this procedure as well, though, i.e., to hide all columns from AG:IV if the value in row 37 is anything OTHER than "Attendance".

For a = 32 To 255
If Range("a37").Offset(0, a).Value = "Attendance" Then
Range("a37").Offset(0, a).EntireColumn.Hidden = True
Next a

View 6 Replies View Related

Hide Rows With Zero In Column

Jul 3, 2007

I'd like to create a command button Macro that will hide all the rows on a given worksheet where the values in a given column equal zero. I'd like to do this to make printing more manageable, so that only the relevant rows (with value>0) print.

View 9 Replies View Related

Hide Rows Where Column Has Zero

Jan 11, 2008

I'm looking for a macro which hides a row when the value of the cell in the E column is 0, but makes sure it's NOT hidden when the value is 1.
(For example; the value of the cell E5 is 0, so row 5 is hidden. The valude of E8 is 1, so row 8 remains).

I've been trying the following code, but it doesn't seem to work for me:

Sub EmptyTest()
If E12 = "0" Then
Rows("12:12").Select
Selection.EntireRow.Hidden = True
End If
If E13 = "0" Then
Rows("13:13").Select
Selection.EntireRow.Hidden = True
End If
...
End Sub

( ... = and so on )

But that doesn't seem to work; it also hides the rows which have the value of 1 in the cell in the E column.

( The value of the cells under E is set by a formula to the value '1' or '0', not false or true or any of that sort. )

View 5 Replies View Related

Macro To Hide Column ...

Jan 15, 2008

I've written a macro to unprotect a sheet, unhide columns and reprotect the sheet. It works fine with 2 out of 3 worksheets. I cant find any reason why it wont work in the one sheet....

View 9 Replies View Related

Hide Row If Corresponding Cell In Column C Is Not Empty?

Sep 3, 2012

I want to hide the row when value "x" is entered in column C

I tried this code in the sheet, but nothing happens.......

VB:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 3 Then
ThisRow = Target.Row
If Not Target.Value = "" Then
ThisRow.EntireRow.Hidden = True
End If
End If
End Sub

So when a "x" is entered in cell (115,C), row 115 must be hidden. When a "x" is entered in cell((9,C) row 9 must be hidden to, and so on. When a cell in an other column is changed, the macro does not need to start.

View 4 Replies View Related

Hide All Blank Columns With VBA Apart From Column A?

Aug 22, 2013

I just want to Hide all the blank columns on the sheet apart from column A.

I already have this code, just dont know how to alter it:

VB:
Sub HideEmptyColumns() Dim c As Long
Dim n As Long
Application.ScreenUpdating = False

[Code].....

View 2 Replies View Related

Macro To Auto Hide Column

Apr 25, 2014

Making a macro to work like this:

if each 4th row of each column (A to XFD) contain 1, hide every column that contain 1 at each 4th row..

So, when the result of my formula is 1 on D4, F4, and AB4, then D, F, and AB column would be hidden automatically when I ran the macro..

View 5 Replies View Related

Hide Column Wend Printing

Oct 4, 2008

I have a form that i use and i need to show some column wend on screen but i don't what them to print out. Is there a way?????

View 2 Replies View Related

Hide And Show Column In Excel?

Jul 27, 2013

I've seen excel sheet view like this [URL].....

View 2 Replies View Related

Hide Rows If Cell In Column K Is Less Than 50

May 15, 2014

I would like the Spreadsheet to Hide rows with less then 50 Quantity on Column K.

I have attached the Inventory List.

If I can create a Button that will automatically Hide all rows with a Quantity less then 50 on Row K that would be great!

View 6 Replies View Related

Hide And Unhide Column With One Button

Mar 11, 2014

Here is my code ( Recorded by macro )

Sub Tally_Chck()
'
' Tally_Chck Macro
'
'
Columns("D:E").Select
Range("E1").Activate
Selection.EntireColumn.Hidden = True
Range("B3").Select
End Sub

I want Hide And Undie Column With One Button...
-Once Click Hide
-Again Click Unhide

View 4 Replies View Related

Column Hide/unhide Macro..

Nov 9, 2008

I am trying to hide/unhide several columns by hitting a button. It's a pretty simple macro to do it once, but how do I get a button to hide on the first click, then unhide on the second?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved