+ Reply to Thread
Results 1 to 3 of 3

Hide control buttons using VBA

  1. #1
    Registered User
    Join Date
    01-16-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    38

    Hide control buttons using VBA

    If you're looking at the excel sheet, what I'm trying to achieve is this:

    As default buttons 5-8 should be hidden. When one of the buttons 1-4 is pressed, button 5 should be un-hidden. When another button, 1-4, is pressed, button 6 should be un-hidden an so forth.
    When any of the buttons 5-8 are pressed, then the highest-numbered button of those visible, should be hidden.

    Say I've pressed all of bottons 1-4, now all buttons are visible. I click on 8, now button 8 gets hidden. I click on 5, now button 7 gets hidden.


    I've come along this piece of code, but can't seem to make it work.

    ActiveSheet.Shapes("YourShapeName").Visible = False
    If anyone can put it in a working sheet, or have a better approach, I'd apriciate it. I guess I'll also need some way to determine how many buttons are visible so I can hide/unhide the correct one, but I think I've got this figured out.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Hide control buttons using VBA

    In a standard code module use

    Please Login or Register  to view this content.
    Assign macro to all buttons.

    in Thisworkbook object use
    Please Login or Register  to view this content.
    to hide button 5 thru 8 on openning
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-16-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Hide control buttons using VBA

    Beautiful

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1