+ Reply to Thread
Results 1 to 6 of 6

Dynamic menu arrays (custom ribbon tab) only partly rebuilt after loss of state recovery

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Dynamic menu arrays (custom ribbon tab) only partly rebuilt after loss of state recovery

    It would be easier to demonstrate this error than describe it!

    I am working on a XLSM file which has a custom ribbon tab, hide-able standard tabs and dynamically sized dropdowns on the menu buttons. Everything appears to be working how I want it except for one thing. If I trigger a loss of ribbon state, the ribbon recovers however whichever dynamically sized dropdown menu button I was on does not auto recover.

    To reproduce the issue:
    1. Download attached workbook
    2. Open the file (There is no developer tab. Alt + F11 to get to the VBA editor)
    3. Click the button 'Test Ribbon for recovery from Loss of State'
    4. Click the End button (this will trigger the macros for recovering the ribbon)
    5. Now click on any of the Menu Labels (1-8)

    Whichever Menu Label was clicked on first will display a blank dropdown list. Now click any of the others - these recovered fine.

    Any ideas how to prevent this happening?
    Attached Files Attached Files
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Dynamic menu arrays (custom ribbon tab) only partly rebuilt after loss of state recove

    I think your problem is here
    Please Login or Register  to view this content.
    because although you reset the ribbon you don't then rebuild the content-you exit the routine. change it to
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Dynamic menu arrays (custom ribbon tab) only partly rebuilt after loss of state recove

    Wow! It fixed it just like that!

    Should I change all my other
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    ?

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Dynamic menu arrays (custom ribbon tab) only partly rebuilt after loss of state recove

    I didn't really look but probably yeah :-)

  5. #5
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Dynamic menu arrays (custom ribbon tab) only partly rebuilt after loss of state recove

    Thanks again.

  6. #6
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Dynamic menu arrays (custom ribbon tab) only partly rebuilt after loss of state recove

    Updated version attached.
    Attached Files Attached Files
    Last edited by mc84excel; 03-11-2013 at 10:05 PM. Reason: workbook wont upload

+ 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