Hi Team,
We have a customUI ribbon and which calls external commads. While the external command macro is running and user is clicking on Excel multiple time then excel ribbons goes into greyed state. Even to select cell we need to double click.
In this case if we minimize and maximize the Excel window then ribbon is getting restored and working as expected. This only happens when user is clicking one excel cells while macro is already running.
We tried adding
before and after that macro but no luck.
We have a customUI ribbon and which calls external commads. While the external command macro is running and user is clicking on Excel multiple time then excel ribbons goes into greyed state. Even to select cell we need to double click.
In this case if we minimize and maximize the Excel window then ribbon is getting restored and working as expected. This only happens when user is clicking one excel cells while macro is already running.
We tried adding
VBA Code:
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.ScreenUpdating = True
Application.EnableEvents = True