hide buttons

  1. B

    Hiding Checkbox Macro in accordance with the Combo Box

    So I am doing an excel project for my accounting class and I have a check box for my income statement that changes the currency of the values when clicked. There is also a combo box on this sheet that allows me to show nothing, the income statement I mentioned, a balance sheet, and a cash flow...
  2. G

    macro to hide all rows with specific text in column B.

    Hi, I am looking for a macro to hide all rows that have the word "detail" in column B. This will ultimately be assigned to a button. I feel like this should be an easy one, but I seem unable to get the If function to work. Any help is appreciated.
  3. andrewb90

    Worksheet Change help

    I am trying to make certain objects hide automatically based on the number typed into a cell. I thought I was doing okay, but the second part of my code doesn't seem to be functioning. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "A12" Then...
  4. zac_fozz

    Macro IF statement to make Forms button visible/invisible

    I am relatively new to macros. I'm using Excel 97. I've made a spreadsheet for our office staff to use to enter their hours worked (and vacation taken, etc.) for the week. At the top of the sheet, the user chooses their name from a drop down menu (in cell B3), created by a Data Validation...
  5. T

    Hide/unhide rows with buttons

    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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...