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

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.

Originally Posted by ByteMarks

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