Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    1 Button 2 Actions ? (Excel 2002/2003)

    Hi

    The macro below is attached to a forms button. clicked once it unhides rows 75:81, is it possible to click the same buton again and do the reverse and hide the rows.

    Sub ShowProduct4()
    '
    ' HideProduct1 Macro
    ' Macro recorded 17/05/2007 by xx0824
    '

    '
    Rows("75:81").Select
    Selection.EntireRow.Hidden = False
    Range("B77").Select
    End Sub

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 1 Button 2 Actions ? (Excel 2002/2003)

    Sub ShowProduct4()
    With Range("A75:A81").EntireRow
    .Hidden = Not .Hidden
    End With
    End Sub

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: 1 Button 2 Actions ? (Excel 2002/2003)

    Hi Hans

    Sorry about the delay in responding but I lost my internet connection.

    Thanks for the code it works just fine.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •