Suppressing ribbon updates

[xwb]

Is there a way of suppressing ribbon updates completely during execution?

I can use ToggleRibbon but that still shows the tabs and during macro execution, they still flash, slowing down everything. I've also tried using it in conjunction with Application.ScreenUpdating but they still flash furiously.

 

[SkipVought]

Hi

Use

Application.Screenupdating=FALSE

 

[xwb]

Application.Screenupdating only supresses the textual updates. The ribbon still updates. If you minimize the ribbon, it still flashes. What I'm asking for is a way to stop the ribbon updating.

 

[SkipVought]

I guess I don't know what you mean by "ribbon updates.

 

[xwb]

If you watch the ribbon, even when ScreenUpdating is false, it keeps on changing. If the text is bold, the bold button comes on, if you go into a table, the ribbon changes to a the table tab etc. It is obvious on fairly longish multi-page documents.

 

[strongm]

> If the text is bold, the bold button comes on

This suggest that you are using the Selection object, since the ribbon reflects the status of the current Selection. Try not to use it ...

 

[SkipVought]

How Can I Make My Code Run Faster? faq707-4105