how to stop user interaction on ribbon while macro is running vba

Madhav Gadve (gmadhav) 0

Hi Team,

We have our custom ribbon and we want to restrict user to click on ribbon button when a preview "button_OnAction" is still running. If user clicked on refresh button and its taking 5 seconds to complete operation then we want to freeze the ribbon until it gets completed. We just want to avoid use to click multiple times on the ribbon.

We have tried "Application.ScreenUpdating" and "Application.EnableEvents" but no luck.

System Details:

MacOS v: 13.1 (22C65)

Excel v: 16.72

John Korchok 6,126 Reputation points

2023-05-27T15:07:03.6+00:00

Here's a Stack Overflow post that may help:

https://stackoverflow.com/questions/53311743/how-to-disable-ribbon-while-vba-code-is-running

Share via

how to stop user interaction on ribbon while macro is running vba

Your answer