IMAGE1.jpg ... This list uses rows up to 1040. What I am needing to do is create a master button similar to the "Show All" Button at the top that hides any sub group automatically based on the values in the yellow box. The hide button to the right of the hardware assembly will hide the rows when pressed but that requires me to go down the list and press each button that the yellow box has a zero in. I would like to create a button that has a macro that will automatically "click" or run the hide button when its corresponding yellow box has a zero in it. If the value is greater than zero it does not need to hide that hardware group.
Example from attached image. If I were to run the new macro it would run the hide button for rows 5-8, not run the macro for rows 10-13, then again run the macro for rows 15-18, and so on until it reaches the last yellow box which is row 1036 (hide rows 1035-1039).
I have a button (A) that will unhide worksheet A. I would like to add another button (B) that will hide(very hidden) worksheet A (if allready open) then open worksheet B, vice versa when click button A.
Code: Sub ShowSheets() With Worksheets("A") .Visible = xlSheetVisible .Activate .Range("A1").Select End With End Sub
I'm using the With ActiveSheet.MailEnvelope command in vb to send an email and it works fine, but the range I am selecting includes macro buttons on the sheet.
It is possible to prevent macro buttons from been printed by selecting Format Control > Properties on the button and unticking Print Object (off by default anyway).
Is there any equivalent way of preventing macro buttons from appearing in emails when a range is emailed rather than printed.
I'm trying to disable the [x] in the upper right hand corner to force my users to use my "Close Workbook" button, but not sure how to do it. Then, was thinking that I might just want to hide the entire Application Title bar...
I am using several toggle buttons to hide/show rows of data related to the specific toggle buttons. I also want to hide and show the toggle buttons as well. When I try to do that the data underneath the toggle buttons is hidden but the toggle buttons don't hide with the cells.
A solution for the problem that I am having would be to have the ability to click on a cell as if it were a toggle button and hide/show rows of data when clicked.
OR
If there is a way to hide/show buttons as well would work too.
1: Is their anyway I can get rid of the File, Edit, View, etc buttons at the top of the document so everyone that opens it can not see them? and also the save button, the idea is they have to use the button to save the sheet.
2: I have a button on the sheet with a macro that saves the sheet once it has been worked on, the sheet flashes when this button is clicked is there any way I can stop the sheet flashing ?
I am trying to create a worksheet that has multiple radio buttons. Each radio button is linked to a Macro. I need there to be many buttons running down one side of the worksheet. Each button needs to perform a macro that is relevant to the cells in the same row that it is on.
Essentially what i am trying to do is make a macro that when the button is pressed copys data from H6 and paste it into B6. The button is situated above I6. I need a button for each row from 6 to 110.
While this macro is easy to create (i use the record button and then assign the macro to the button), i would have to do this 104 times and assign a new macro to each button.
Is it possible to change the color of buttons or command buttons? There does not seem to be any place that allows this under properties for buttons, although there does for command bars. However, I've tried recording a macro as I change the color, but nothing get's recorded so I'm not sure what the syntax would be.
I have a spreadsheet with several buttons and I'd like them to change colors as they are pressed so it's possible to see what you've already done. And then, as soon as any other cell on the sheet is changed, the buttons reset color.
I am trying to make a basic worksheet that will have radio buttons. I have searched around for about 2 hours and can not find any documentation on how exactly to create a buttons and make it do what I want. I have also tried F1 in Excel but that hasn't helped any either. I did stumble uppon a file called "Options.xls" when searching this forum but it does not explain how the buttons were made. The only thing i can figure out how to do is basically insert a button onto the document, and rename the label of the button that's about it. I basically want to create a group of (3) or so buttons. If button A is picked, cell D1 will display "x". If button B is picked, cell D1 will display "y", and so on. Is there a link to an example out there that shows how to create and use buttons?
by using radio buttons or checkbox, or anything similar. Based on the answer, I would like cells to appear below the question, for example in B3 another question would be "how many guests would you like to invite?" and B2 would be their answer but is preset to "0"
Where the cells are empty, they are reading #VALUE! because I have copied down a formula in all other cells above and below etc.
Is there any quick way of making the #VALUE! disappear or by hiding?
(Other than the copied formulas in the column, there are also conditional formatting so when the numbers drop below zero value, it turns the numbers red).
It's a long sheet and I want to avoid deleting each #VALUE! by hand!
I have a work sheet with 4 pages. I enter a value on page 4 & copy it to page 1. The formula
=complete!(h4)
entered on sheet 1 will enter a $0.00 untill I have a value entered on sheet 4 (which is named complete)cell H4. I want to hide all those zero's, in a search I found this code,
Option Explicit
Sub HideCol() Dim cl As Range, rTest As Range
Set rTest = Range("a1", Range("a1").End(xlToRight)) For Each cl In rTest If Not cl.Value > 0 Then cl.EntireColumn.Hidden = True End If Next cl End Sub
Is this the best way to hide all those zeros? & when I get a value in cell h4 will the it then show?
I have several, up to maybe 100 cells in different place in a worksheet, that we don't want to be printed. Until now we changed the text colour for the cells to white, but we noticed that the PDF-files wills til have the "invisible" text. Copy the document text to let say notepad, will show the "hidden" text in the cell.
We have to have another solution to it. Like a macro telling not to print the cell where white text is present.
I am trying to hide rows if cetain cells in that row equal zero using a button on the page. Each cell has lookup formulas that will return a value. If coulmn B,F & I have a value of zero I want to hide the row. As of right now I am using the following code but I keep getting the following error message runtime error '13': type mismatch
I would like to create a rather simple event macro. Everytime when something is selected from cell A1, which has a validation list, I would like to check the following:
Check if cells within the range B7:B10 have value zero, when they have, hide the respective row. So either hide 0, 1, 2, 3 or 4 rows.
Check if cells within the range H15:H18 have value zero, when they have, hide the respective row.
Is it possible to hide ("make the text invisible") cells, but if you filter the column, it will still filter on the data inside the hidden cell but not on the data you only see? I want to hide the cell data for layout purposes.
I have two options in a Cell as Applicable and Not Applicable. This is in a Drop-down menu and what I want is that when I choose Applicable, it should bring up additional 5 or 6 cells for me to complete. And if I choose Not Applicable, the additional cells should not show up. The default would be Not Applicable.
I want to be able to select a range on my spreadsheet, click a button, and have everything that is not selected hide itself. I've tried using intersect, but I'm not sure how to (quickly) loop through all of the columns and rows to see if my range is contained within.
I have been using this code for a long time in Excell that came with OfficeXP very sucessfully. I just upgraded to Office 2003 and this code will not work.
Sub HideCells()
'This converts weeks with no production to an error value 'in row 14 then hides the column that holds the error value 'This is to create a dynamic graph
On Error Resume Next Rows(14).SpecialCells(xlCellTypeFormulas, xlErrors).EntireColumn.Hidden = True
I am basically making a sheet that counts attendance, everytime an X is placed in a particular cell another cell counts that x. So if there are 25 x’s in one row, another cell will automatically add those x’s to show 25. That isn’t my problem. My Problem is the cell that contains the countif formula that adds the x’s are all 0 if there is no data for it to add. I want to make it blank because right now I have a whole bunch of 0’s going down one column and can’t figure how to get rid of it. Right now I am using: =COUNTIF(C20:X20,"x"). I normally would take the time to research and look through your forums however I do not have the time at the moment and was hoping for a fast answer.
I am creating a form in excel and need to hide a selection of cells, not an entire column, or an entire row, but the cell range K43:K48. I want these cells to be hidden at all times unless any one of H44:H48 has the value "Other" inputted.
If Other is selected I want range K43:K48 to become unhidden. Is there any way to do this?
I have tried to use Conditional Formatting to do this, but only being able to use 3 conditions makes it harder to do when I have a range of 5 cells that could display "Other:"
