+ Reply to Thread
Results 1 to 3 of 3

problem ribbon option ghost after run a large macro

  1. #1
    Registered User
    Join Date
    03-22-2020
    Location
    Colombia
    MS-Off Ver
    Office 365
    Posts
    10

    Unhappy problem ribbon option ghost after run a large macro

    Hello everyone

    I have a macro that process a lot of data and copy some of them to many sheets, when it finished, my ribbon has a kind of transparency only when the active sheet has some data, but if the sheet has a little data or nothing, the ribbon works perfect.

    I solved it when I close the file and open again, but I want run the macro and that the ribbon works, I attach a pic from my problem, but I don't know how to fix it without close the program.

    I apreciate your help guys

    Pd. my macro is too large so I had to divide it in parts, made a new sub and call the parts for run it.

    Sin título.jpg

  2. #2
    Forum Contributor
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit
    Posts
    265

    Re: problem ribbon option ghost after run a large macro

    I had s similar problem (only in O365) where, after the macro had finished the ribbon was completely blank - no buttons at all.
    I managed to fix this by activating the file which has the macro periodically and putting in more "doevents" to slow it up. Screenupdating was already disabled.

  3. #3
    Registered User
    Join Date
    03-22-2020
    Location
    Colombia
    MS-Off Ver
    Office 365
    Posts
    10

    Re: problem ribbon option ghost after run a large macro

    Quote Originally Posted by ByteMarks View Post
    I had s similar problem (only in O365) where, after the macro had finished the ribbon was completely blank - no buttons at all.
    I managed to fix this by activating the file which has the macro periodically and putting in more "doevents" to slow it up. Screenupdating was already disabled.
    Hi, I've been trying fix the code with your suggest, I put many "doevents" and sometimes works and others doesn't. I tried to delay more the macro with the sub "sleep", but is the same result, anyway, thanks mate for your help

+ 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. Replies: 2
    Last Post: 08-03-2017, 11:11 AM
  2. Ribbon is missing slicer option
    By stephme55 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-11-2016, 06:25 PM
  3. [SOLVED] Problem with macro created ribbon tab
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2016, 07:22 AM
  4. Data option locked from ribbon - How do I unlock?
    By amraftice in forum Excel General
    Replies: 2
    Last Post: 06-14-2013, 09:38 AM
  5. Ghost Macro
    By Aaron5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2006, 10:50 AM
  6. ghost macro
    By gevans in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-08-2006, 12:45 PM
  7. I seem to have a ghost macro.
    By SongCoyote in forum Excel General
    Replies: 1
    Last Post: 09-12-2005, 09:05 PM

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