Hide Row On Click

Dec 29, 2009

Looking for a way to hide a given area of either rows or columns using a hide/unhide button command.

View 9 Replies


ADVERTISEMENT

Show Hide Rows On Click?

Jan 5, 2007

Is it possible to hide the contents of a column that would only show once clicked on?

That way i could have a column called "Keywords - click to open" & the contents would only show once clicked on?

I have uploaded an example excel spreadsheet : example show hide.xls

View 9 Replies View Related

Hide Columns With A Click On A Button

Mar 16, 2007

I want to be able to have a set of buttons or a dropdown menu where i can put all the titles of my columns in.

After clicking on one of the titles the column must hide or show itself, is there a way to do this?

It's for an automated sheet wich contains a lot of information and this will be used by a lot of people, i want to make it easy for people to simply generate a sheet with just the info they need.

View 9 Replies View Related

Show Hide Rows On Click

Jan 5, 2007

if it is possible to hide the contents of a column that would only show once clicked on?

That way i could have a column called "Keywords - click to open" & the contents would only show once clicked on?

View 9 Replies View Related

Hide Title Bar / Ribbon - Disable Keyboard Functions And Right Click?

Apr 24, 2014

Below are the codes to hide the objects within Excel, Disable Keyboard shortcuts and disable right click, all are placed in the ThisWorkbook and i placed them in a 'Private Sub Workbook_Open()' function.

VB:
'Change 'False' to 'True' to unhide
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayHeadings = False

[Code]....

There maybe simpler ways to do the above i just don't know them, it's just these have worked for me and i have had zero bugs come back from them!

View 2 Replies View Related

Macro Button Click - Show / Hide Set Of Grouped Rows

Nov 12, 2013

I found this code for a button, so I can collapse and expand a set number of rows within that sheet. It works exactly the way i want it to, however, now I have a second sheet in my workbook, and I used the same button. Problem here is that when I activate the button, it opens the same rows in EVERY sheet in the workbook. "For each ws in Worksheets" so my question is what is the term for it to only work on a certain worksheet?

Code:
Private Sub ToggleButton1_Change()Application.ScreenUpdating = False
Dim ws As Worksheet
With ToggleButton1
If ToggleButton1.Value = True Then
For Each ws In Worksheets

[Code] ........

Other questions is about the ability to send an MS Outlook email from inside of excel.

I've been trying to find something that does the following:

Click button, Form pops up, has drop downs to select recipient, has field for subject, has field for message body, sends email.

View 2 Replies View Related

Macro To Right Click A Cell And Select Item From Right Click Menu?

Feb 7, 2014

I wonder if it is possible to make a macro that right clicks a cell and then chooses a option from the list?

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

Click The Master Button, That Would Click Another Button On A Different Worksheet

Oct 22, 2008

Running into this issue of "transworksheet macros"

I have a master "update" commandbutton on sheet 1. I have two sub "update" buttons on sheet 2 and 3 respectively.

What I would like to do is have the user click the master button, that would "click" the two sub buttons so they run their respective macros on their respective worksheets (within the same worksheet.

I have tried pasting the macro code in the master button, telling it to select the sub worksheet and then run the macro, but the marco runs itself on the master worksheet instead.

View 6 Replies View Related

Hide Specific Rows In Sheet1 And Hide 5 More In Sheet2?

May 26, 2014

I have a macro in which i can enter the rows i want to hide.

If i want to hide "position 32" i have to enter the number 8 of the row. This works fine. But now if i want to hide the "position 32" from Sheet1 it also should hide the rows 4-8 from Sheet2 [Data with 32].

Or if i hide "position 34" in Sheet1 [row 10] it also should hide the rows 14-18 in Sheet2.

View 14 Replies View Related

VBA - Button Command To Auto-Hide Rows With Value HIDE

Jun 9, 2013

Sub Button294_Click()

If Sheet1.Range("A34:A94") = "HIDE" Then
For Each cell In Range("A27:A94")
If UCase(cell.Value) = "HIDE" Then
cell.EntireRow.Hidden = True
End If
End Sub

View 4 Replies View Related

Hide Columns & Hide X-axis Labels

Nov 22, 2006

I am filtering the data displayed in a chart by hiding columns. I would also like to filter the X-Axis labels by hiding columns. If I do this manually I have no problems but when I run the following macro the chart gives a reference error for the X-axis labels.

Sub ShowA2()
Application. ScreenUpdating = False
num = Sheets.Count
Sheets("X-Axis").Activate
Range(Columns(1), Columns(256)).Select
Selection.EntireColumn.Hidden = False
For a = 1 To 5
Sheets(num - a).Activate
If ActiveSheet.Name = "A2 Data" Then
Columns("A:Q").Select
Range("A10").Activate
Selection.EntireColumn.Hidden = False
Sheets("X-Axis").Activate
Columns("A:E").Select......................

View 3 Replies View Related

Click On Color Button And After Button Click It Will Color Entire Row Of Cell?

Jan 23, 2014

what code I can put behind a button so that once I click on that button,

What ever cell i click on, the whole row of that cell will be colored a certain color.

Is this where i would used a target approach?

View 6 Replies View Related

If A1 Is Also Found Below A1 Then HIDE Otherwise DON'T HIDE?

Dec 12, 2013

If A1 is also found below A1 (A2,A3,etc) then "HIDE" otherwise "DON'T HIDE"

I want to create a formula which finds out if a value exists below it in the same column. I could then use a filter to remove rows contain the word "HIDE" which will leave me with only rows with DON't HIDE. Then Column A will only contain unique values.How would I create a formula like this?

View 5 Replies View Related

Can't Right Click

Jan 20, 2006

for some reson two of my macros's attached to two pics in my worksheet have
'dropped out' and the right click has been somehow disabled so I can't edit
the pics so that I can reattach them.

The worksheet is full of various bits of VB code (most of which has been
donated from here) so I don't even know where to start looking in the VB
editor for the potential problem.

View 14 Replies View Related

Where Did My Right Click Go

Mar 13, 2008

So I found some VBA code on the board that I thought I understood..It replaces paste with pastevalues...so I run the code to see how it does and everything seems great...but...NOW...whenever I open ANY workbook and try to paste by right clicking and (attempting to) choose paste special all of a sudden the test workbook that I made opens up on it's own and runs the pastespecial macro. Why??? I put absolutely no code in the workbook that I had opened when this happened. I loaded the macro into the workbook sheet of the test workbook only. Also, it's only if I right click...ctrl+c works without the macro running...selecting paste special from the menu works as well...but no right click.

The code is as follows:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

Dim UndoString As String
Dim srce As Range

On Error GoTo err_handler

View 9 Replies View Related

Click On, Click Off

Jun 19, 2008

when i click on a specific cell, a big green check mark appears. Click on it again and it disappears. The value assigned to this check mark is 1 and 0 when its off. (for future programming purposes)

The data area on the spreadsheet is from A1 to L80. The check marks would be in column L.

I know i can use a control box for this but i would prefer this method if possible.

View 9 Replies View Related

On Click, Copy

Nov 26, 2008

I have a worksheet containing lot of data in A,B,C, D,E,F. If it is possible that whenever an entry in a column is clicked or double clicked, it may be pasted to another sheet or in a blank column of the same sheet.

View 5 Replies View Related

Right Click Option

Jun 7, 2009

I lost my right click option in excel, all I get is a little gray box that does nothing. I know it is something I did today, it has worked perfect before. Has anyone seen this happen, the problem is only in excell 2003.

View 2 Replies View Related

Click To Copy

Jan 23, 2007

I am trying to copy a cel
l by assigning a macro to a text box or shape. The cell I want to copy is out of sight of the current view (it's a password) and I just want to click on the box or shape. I can do it when the current cell is active with 'ActiveCell.Offset', but not if I click on it when it is not the active cell.

View 9 Replies View Related

Disable Right Click. Can It Be Done?

May 1, 2007

Need code or way of disabling the Right Click feature in Excel? I think you can change it in the computer settings but I only want to disable it for a particular workbook so I am hoping there is a VBA Code that will tell the user "Right Click Not Allowed, Please use Cut and Paste or Ctrl +V and Ctrl +C"

View 9 Replies View Related

VBA Click On A Link

Jun 2, 2008

I need to find a way to have Excel find a link and click on the link in Internet Explorer.

The link name is unique in the page, and the href looks something like this.

HTML Code:

View 9 Replies View Related

Right Click Options Are Gone

Sep 19, 2008

I recently added a macro in excel that stopped users from cutting and pasting and dragging etc. I got the macro from the web. I have delete the macro, but for some reason I cannot get it back to normal. If I right click on a cell the cut, copy, insert, delete, format cell menu is grayed out. The undo button also does not work? I have searched for the macro and deleted it but it seems to have changed something else. I have even tried to disable macros, but all menu items are still gone?

View 9 Replies View Related

Go To Cell Upon Click

Nov 24, 2006

I have a worksheet dealing with customer order numbers in rows and various information about those orders in columns. The first 10 rows contain generic " header" type information with formulas to return certain values from the data below. Panes are frozen below row 10 so I can manually scroll down to see data. My "line numbers" (1,2,3,etc.) are listed in column "A", and begin on worksheet row 11.

The worksheet is set up so that when I enter a customer order number in cell "F2", my line number (Excel row + 10) is returned in cell "L2". I would like to use a Macro that would give the user the option (possibly with a button) to automatically scroll to the report line number returned in cell "L2".

View 3 Replies View Related

Can't Right-click Textbox

Jan 23, 2007

I created a textbox in excel, but i can't seem to do a right click, such as copy and paste..

I know that ctrl-C, and ctrl-V works, but the spreadsheet is mainly for non-tech savvy individuals,

View 8 Replies View Related

Vba Click Count

Mar 27, 2007

What code would you use to count the number of times a subprocedure has been executed? And then insert that count into a cell...

View 8 Replies View Related

Value In Cell Upon Click

Jun 6, 2007

Any way to make it so that if a user clicks into any single cell in columns O to AH, it will populate the cell with an X?

So if user clicks on cell, populate with X.

View 9 Replies View Related

No Right Mouse Click

Apr 22, 2008

I use Excel XP 2002. I now can't copy /paste by using the right mouse button. It works perfectly in other MS products, on the net and on the desktop. l have checked my Tools/Options with other users, I have uninstalled, rebooted and reinstalled the complete Excel package but the problem persists, even from start with a blank worksheet. I have also checked and there are no add-on ticked.

View 5 Replies View Related

Search Two Value In Two Column In One Click

Jun 13, 2008

How to search two values in Two cell in one click. For example

My Input Values

Column A Column B
Apple Cake
Apple Juice
Apple Icecream
Mango Cake
Mango Juice
Mango Icecream

View 14 Replies View Related

Text To Columns Can Be Done In One Click

Dec 3, 2008

In one column J there are five digit numbers like 45678.Can with the help of a formula or code/macro, the process of text to columns can be done in one click, instead of going through the process available so that the data is scattered in J,k,l,m,n columns.

View 3 Replies View Related







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