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

Madhav Gadve (gmadhav) 0 Reputation points
2023-05-26T22:28:53.6366667+00:00

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,501 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,538 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
467 questions