Hide Column On Double Clicking Certain Cell

Feb 1, 2009

I want to hide and unhide column AI by double clicking on a certain cell, let's say S25. Can this be done?

View 8 Replies


ADVERTISEMENT

How To Get A Userform By Double Clicking A Cell

Jul 26, 2008

how to get a userform by double clicking a cell.

I have created a userform, (my first one)-very simple form, i have created a massive textbox, so when i doubleclick a cell in Sheet 1, userform pops up and I can write comments.

I am not sure how to write a code for this? I know it will have Private Sub Doubleclick, not sure on the rest?

View 9 Replies View Related

Combine Two Macros And Run Them On Double Clicking A Cell

Mar 20, 2009

I have two pieces of code. The first one puts a tick mark in the cell when you double click it. The second one hides column B of another sheet if the value in cell A1 of Sheet1 is "a". I want to combine these two codes so that when I double click cell A1 of sheet1 it puts a tick mark in the cell and hides column B of Sheet2 and clears the contents of range B2:B50 of Sheet2.

View 4 Replies View Related

Auto Hide / Unhide Rows By Clicking On A Cell

Aug 23, 2013

I have a very long spreadsheet and want to keep it manageable by hiding rows until they are needed.

Example:

Column

Row A B C D E

1 Line1
2 Reg
3 OT
4 Min
5 Line2
6 Reg
7 OT
8 Min

I want to click on A1 and auto hide rows 2-4. Then I want to click on A1 and auto unhide rows 2-4. Then I would copy the idea to Line2, etc.

View 4 Replies View Related

Change Automatically Without Double-clicking?

Apr 14, 2014

A
B
C
D
E
F
G

I have a spreadsheet with formulas in column C, D, E, F and G. The only numbers I need to enter are in columns A and B. The formula in column C comes from the =SUM(B1/A1) Column D is calculated based on the result of column C, etc...

How can I set up the spreadsheet so that when I enter the data in column A and B, everything else calculates automatically; without having to double click and press enter in each cell?

My Goal: To put data (numbers) in Column A and B and than have C, D, E, F and G calculate by themselves without clicking.

All of my cells contain numbers, not text

View 6 Replies View Related

Excel 2010 :: Double Clicking Rows Is Not Expanding To Wrapped Text?

Mar 31, 2014

My cells have wrap around text enables. However when I double-click the row, it does not automatically adjust the row height to accommodate all of the text. It shrinks to a small row height. How do I fix this?

View 1 Replies View Related

Excel 2010 :: Double-clicking On Pivot Table / Multiple Worksheets

May 31, 2011

I upgraded to Excel 2010 from Excel 2000 a couple months ago. In Excel 2010, after double-clicking on values in a pivot table to create a new worksheets, I'm unable to highlight those worksheets and add a column to all of them. I was able to do this in Excel 2000... I can't figure out what's stopping it from happening for the life of me. Am I missing something obvious here?

View 3 Replies View Related

2 Instances Of 2007 Slow To Open A File By Double-clicking And Entering From Windows Explorer

Sep 20, 2007

i use excel 2007, it s slow to open a file by double-clicking and entering from windows explorer, by googling i fould a fix by adding "%1" at the end of command in "Application used to perform action" (folder options/file types/xls/advance/open). however, to open files in the same instance, i have to keep "DDE message" with [open("%1")]. With both "%1", excel now opens twice.
How to fix it?

View 3 Replies View Related

Hide Columns In Sheet Based On Value In Double Clicked Cell

Jun 4, 2014

I have a workbook with two sheets, Project Overview and Projects Detailed. In Project Overview column K is different project numbers and what i need the code to do is when this number is pressed it has to go to Projects Detailed and search for this number in column AV and hide the lines that does not correspond with the number that has been double clicked.

In project overview you should only be able to press the numbers from row 9 and down and in Projects Detailed the numbers in column AV also starts in row 9. Some of the cells in column AV are empty and these should also be hidden.

View 2 Replies View Related

Open Formula Sheet And Hide All Sheets Except Clicking Hyperlink

Feb 22, 2013

I have a file having around 57 sheets.But here,I have taken a example.I want a file whose show me only summary sheet.But when,I click the cell no.C7 then the related sheet should be open i.e.FNDADRSCC,and all the sheets should be hide.I have little knowledge of HYPERLINK formula but not to the desired stage.

For more clarification, refer attached file.i.e. BOM Sheets

Desire result file have attached also i.e. Excel_formula

View 1 Replies View Related

How To Double Click On A Cell In Column

Dec 5, 2011

I want to be able to double click on a cell in a column. If it has a certain word in it, it will take it to that worksheet. Auto filters are used so these cells can move in a column at any time. This is why I am looking for a code to validate the contents in the cell first.

ie. Cell has the word: BSALT, when double clicked it will take it to the BSALT worksheet.

Cell has the word MLW, when double clicked it will take it to the MLW worksheet.

And so on.

These values are in one column only. If they weren't able to be autofiltered i could do it, but the mere fact that they can move around is giving me trouble.

View 9 Replies View Related

Excel 2007 :: Cannot Delete Column By Right Clicking

Dec 3, 2013

In any open (new or existing) workbook (Excel 2007), I cannot delete a column by right clicking the column header and highlighting the entire column. The "delete" word is greyed out and not selectable. I CAN however still delete a column by going to the "Cells" toolbar, then "Delete" pulldown menu, then "Delete Sheet Columns". Right clicking the column header is much simpler and easier.

BTW, I can still delete rows by both methods of right clicking on the row header and by going to the Cells toolbar.

View 5 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 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 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 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 Column If Cell Value Is Null

Dec 28, 2008

I need a quick macro I can run to hide the columns if the formula result for cells B1:AA1 is "" (null) instead of text. This runs explicitly on Sheet2. Array VBA is still geek to me.

View 4 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

Hide Row If 3 Cell In Column Is Blank In Pivot?

Jul 11, 2013

I want to hide the rows if 3 cells in column B to E is empty (see Result)

Original Table

A
B
C
D

[Code]....

View 9 Replies View Related

Excel 2007 :: VBA - Hide Column If Cell Has No Value

Dec 27, 2012

Code:
A
B
C
D

2
34

If I had columns as above with values in B1 and C1 but none in A1 and D1

How do I loop through so that columns A and D are hidden?

My spreadsheet has columns A to DI and different columns have values each day so I want to write code to hide just the columns with no values.

View 6 Replies View Related

Hide Column Based On Another Sheets Cell Value

Apr 16, 2008

There are 2 sheets in the excel worksheet. in one sheet there would be drop downs
the 2nd sheet will have 4 columns A,B,C,D) Depending on the selection in sheet1. If a1 = Y then columnA in the 2nd sheet should be hidden. If a1 = N then columnB in the 2nd sheet should be hidden. how can this be done..The key is the columns to be hidden are on a different sheet and that is where I am having the difficulty.

View 3 Replies View Related

Hide Rows Based On Cell Value In Column

Jun 12, 2008

I would like to hide rows (A17:A180) based on the value in the cell. If the value in a specific cell is "X", hide the row...if anything else is in the column's cell (A17, etc), show it.

View 6 Replies View Related

Excel 2007 :: Clicking On Cell Auto-selects Cell Next To It - Cannot Disable

Nov 16, 2010

Whenever she clicks on a cell, the cell to the right of it is also selected. When she tries using tab to move to a new cell, she can only move between the two selected cells. Same with using the enter key. As such, it is extremely difficult for her to modify only one cell, since she always has two selected.

The F8 key, as well as Ctrl+F8. However, pressing the F8 key only adds more cells to the autoselection, and Ctrl+F8 allows her to select one cell, but also highlights the cells around it, and when we tried to select other cells, every cell we clicked stayed highlighted.

Additionally, sometimes when she clicks a cell, it will just select that one cell. Click it again, and the problem is back. I haven't been able to determine any patterns to this behavior, and I know there is no problem with the input (the keyboard and mouse are standard-issue in our lab, and we keep them well maintained).

View 8 Replies View Related

Excel 2010 :: Changing Cell Color And Border By Clicking A Cell

Apr 25, 2014

I would like to accomplish 2 things in my Excel 2010 spreadsheet by click a cell which already has a number and formatting in it.

1. How do I change the color of the cell, the color of the number in it, and the border around it. (Make it look like I just pressed a button by clicking it.)

2. At the same time have the text in different cell and the number in the selected cell appear in another different cell. (Text in a different cell = A , and the number in the selected cell = 23, the value in the resulting cell be "A 23") Everything I would like to happen at the same time by clicking the selected cell. I would also like this to be done several times by clicking different cells and not changing the previously selected cells.

View 1 Replies View Related

Run A Macro By Clicking A Cell

Nov 6, 2008

I would like to run a macro by clicking a cell. I don't want a toolbar button/menu item and Hyperlinks don't work. Can this be done?

More info: My macro selects the current row in Sheet A and moves it (cut & Paste) to Sheet B in the workbook. The macro then goes back to Sheet A and deletes the now blank row.

View 6 Replies View Related

Hide Column And Clear Contents Based On A Cell Value In Another Sheet

Mar 19, 2009

I have a workbook with two sheets of data. I want to hide column B of Sheet2 and clear contents of range B2:B50 if the value in A1 of Sheet1 is "a".

View 2 Replies View Related

IF Formula With Double Contents In A Column

Aug 15, 2009

the formula i used is " =IF(A2=A3;"YES";"NO")

the contents are as follows

A
Numbers

2525 - YES
2525 - NO
2526 - YES
2526 - NO
2528 - NO
2530 - NO
2527 - YES
2527 - YES
2527 - NO

how can i use a formula... that tells the last double entry yes too instead no?
for example above...

2525 - YES
2525 - NO (i want the formula say this "YES" too..)

So i want to find out through filtering.. all the double entries with YES.. so i can work with it without missing any double entries.

View 3 Replies View Related

Changing Cell Data By Just Clicking On It.

Apr 6, 2007

i have made (found) a way to change the data in a cell by clicking on it, however i can only make it go from 1 to 0 or 0 to 1...heres the VB
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
If (ActiveCell.Value = 1) Then
ActiveCell.Value = ""
Else:
If (ActiveCell.Value = "") Then
ActiveCell.Value = 1
End If
End If
End Sub

however, i would like the code to do a different task, i would like it to add one to the number everytime you click on it...i.e. it goes from 1 to 2 to 3 to 4 to 5 etc. everytime you click on it...

if it is possible, i would also like it to be restricted to a few cells, which i can determine afterwards and change

View 14 Replies View Related

Clicking On A Cell To Get Additional Details

Feb 3, 2009

I have seen this on many spreadsheet but never figured out how to do this - click on a cell in a spreadsheet to open up a new spreadsheet?

View 4 Replies View Related







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