+ Reply to Thread
Results 1 to 3 of 3

Custom ribbon button will not check checkboxes

  1. #1
    Registered User
    Join Date
    07-21-2010
    Location
    Bakersfield, CA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Custom ribbon button will not check checkboxes

    I have a custom ribbon with checboxes that will show/hide sheets. I have added a button that will show all three sheets. I would like the button to set all three checkboxes to true as well. Thanks!
    Attached Files Attached Files
    Last edited by ericsastud; 10-29-2010 at 05:33 PM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Custom ribbon button will not check checkboxes

    You need to set up an onLoad hook in your custom XML for the workbook so that you can store a reference to the Ribbon. Then your macro can invalidate the ribbon after changing the sheet visibility so the checkboxes will fire their callbacks and reset their checked states. See attached.
    Attached Files Attached Files
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Custom ribbon button will not check checkboxes

    PS When your questions are solved, as I assume your last one is, please mark them accordingly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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