Button for hiding rows - complete newb - never used Macros

[tom_j]

OK - don't use excel much more than the standard functions, but I do have a fairly robust to-do list that has data associated with it. What I am trying to do is creating a button (or link - does not need to be fancy) that I can put in to each row that will invoke the row-hide function. I also want to put a timer on it so it only hides it until the next day (12:01 AM)

Would love some help!

 

[cstimart]

OK - don't use excel much more than the standard functions, but I do have a fairly robust to-do list that has data associated with it. What I am trying to do is creating a button (or link - does not need to be fancy) that I can put in to each row that will invoke the row-hide function. I also want to put a timer on it so it only hides it until the next day (12:01 AM)

Would love some help!

Here's some info you can use (for starters) to fit your needs.

Alt-F1
Insert/Module
Paste in the following code

Sub Macro1()
    ActiveSheet.Buttons.Add(434.25, 14.25, 65.25, 21).Select
    Selection.OnAction = "Macro2"
    ActiveSheet.Shapes(1).Select
    Selection.Characters.Text = "Hide Rows"
    [A1].Select
End Sub

Sub Macro2()
    Rows("8:8").EntireRow.Hidden = True
End Sub

Press F5 and select Macro1, if prompted.