+ Reply to Thread
Results 1 to 7 of 7

Hide ActiveX Checkbox on worksheet

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Hide ActiveX Checkbox on worksheet

    I have a radio button that when true will hide a column. Column has checkbox I also want to hide - but it's not getting hidden with the code below. Any ideas?

    Please Login or Register  to view this content.
    The properties indicate the visible value is changing to false, but I can still see it (Design Mode is off).

    Thanks for any help.
    Last edited by ker9; 04-13-2011 at 04:45 PM.

  2. #2
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Hide ActiveX Checkbox on worksheet

    You will have to change the visible property to hidden when that radio button is true...so it will hide along with the column.
    Last edited by jwright650; 04-13-2011 at 04:33 PM. Reason: added example file
    Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
    John Wright

  3. #3
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Re: Hide ActiveX Checkbox on worksheet

    I am not hiding the radio button - I want to hide the checkbox. Even thought the code changes the checkbox's visible property to false, it is still visible.

  4. #4
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Hide ActiveX Checkbox on worksheet

    Check out my example...if I can get it to upload...the site is still loading all of the gifs on the page.....


    I used your code...just changed the object names to match my sheet.
    Attached Files Attached Files
    Last edited by jwright650; 04-13-2011 at 04:36 PM.

  5. #5
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Hide ActiveX Checkbox on worksheet

    re: my example
    Is that what you wanted to do?

  6. #6
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Re: Hide ActiveX Checkbox on worksheet

    argh! Yours is working and mine wasn't. Why... I thought, well, maybe the box is not totally in the column, so I started messing with that and making sure it was completely in the column. No change. Then I moved the box completely out of the column and behold - somehow there was a 2nd checkbox directly under my checkbox (who knows why or how) and that was what was not getting hidden.
    Thanks very much for trying to help me!

  7. #7
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Hide ActiveX Checkbox on worksheet

    Quote Originally Posted by ker9 View Post
    argh! there was a 2nd checkbox directly under my checkbox (who knows why or how) and that was what was not getting hidden.
    Thanks very much for trying to help me!
    LOL...it's been one of those days here at work too.....

+ 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