+ Reply to Thread
Results 1 to 2 of 2

Refreshing the ribbon interface before a call from a macro

  1. #1
    Registered User
    Join Date
    01-19-2021
    Location
    cocha,bolivia
    MS-Off Ver
    2016
    Posts
    1

    Refreshing the ribbon interface before a call from a macro

    When creating custom ribbons, at some points in the application I need to be able to enable and or disable the button commands.

    The problem is that I can't get the ribbon to refresh before of call macro main to enable the Pause Button

    Please Login or Register  to view this content.
    Last edited by ElmerCC; 01-19-2021 at 11:12 AM.

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

    Re: Refreshing the ribbon interface before a call from a macro

    The invalidate will not occur until you exit the Run_OnAction routine, which does not happen in your code.

    You could use the Application.Run to start the process AND let the onAction routine complete.
    I'm not sure about the rest of the code though as the Pause button will not get invalidated because you are stuck within the other routines that are looping.

    It may make more sense when you use real code rather than forced loops.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Call the value conain in an Edit Box in a personal Ribbon and use it in macro
    By cpmsimoes in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-13-2017, 12:37 PM
  2. Oracle Call Interface(OCI) C DLL function calls and void functions
    By Gregor y in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-15-2015, 01:31 PM
  3. Web Services function call and data refreshing
    By Jonathan Stone in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. Web Services function call and data refreshing
    By Jonathan Stone in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. [SOLVED] Web Services function call and data refreshing
    By Jonathan Stone in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. Web Services function call and data refreshing
    By Jonathan Stone in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. Web Services function call and data refreshing
    By Jonathan Stone in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-31-2005, 10:05 PM

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