1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 07 - Macro to hide/unhide rows

Discussion in 'Business Applications' started by psychocowboy, Nov 11, 2008.

Thread Status:
Not open for further replies.
  1. psychocowboy

    psychocowboy Thread Starter

    Joined:
    Nov 11, 2008
    Messages:
    2
    I am building an excel model and want to link a macro to the "calculate" button based on the above check boxes. If the boxes are selected, the relevant graphs would need to unhide and show and then hide as the boxes are deselected again.

    I've attached a screen shot of what I'm working on.

    I would appreciate any help possible on how to write the code for this macro.

    Many thanks
     

    Attached Files:

    • Help.zip
      File size:
      11.6 KB
      Views:
      134
  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,503
    Welcome to the board. :)

    Screenshots saved as bitmaps are huge. Convert them to (e.g.) jpgs, then you can upload without zipping. :)

    Re this part of your post specifically:

    Macro to hide/unhide rows

    , one "basic" answer is:

    Private Sub CheckBox1_Click()
    If CheckBox1 = True Then
    Rows("11:20").EntireRow.Hidden = False
    Else
    Rows("11:20").EntireRow.Hidden = True
    End If
    End Sub


    Do you actually have ten charts, or is it far more in reality?
     
  3. psychocowboy

    psychocowboy Thread Starter

    Joined:
    Nov 11, 2008
    Messages:
    2
    Thanks for the help dude! It's made a huge difference!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/768085

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice