Jumpy73
New member
- Joined
- Oct 30, 2018
- Messages
- 2
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 2016 64bit
Hi All,
I'm a newbie of this forum and of VBA programming too
I run a subroutine through the AssignMacro attribute of a worksheet button (no ActiveX) with good performance.
If I call the same subroutine through the callback procedure linked to the OnAction attribute of a custom UI Ribbon control, it runs very slowly
Some additional info:
- At the beginning/end of the subroutine I use the classical Application.method to speedup vba executing (ScreenUpdating, Calculation, EnableEvents and so on)
- the subroutine code programmatically invokes the results of pivot tables included in a different worksheet in respect of the active worksheet
Unfortunately I can't figure out the reason of this supposedly strange behaviour.
Any help it would very appreciated
Regards,
I'm a newbie of this forum and of VBA programming too
I run a subroutine through the AssignMacro attribute of a worksheet button (no ActiveX) with good performance.
If I call the same subroutine through the callback procedure linked to the OnAction attribute of a custom UI Ribbon control, it runs very slowly
Some additional info:
- At the beginning/end of the subroutine I use the classical Application.method to speedup vba executing (ScreenUpdating, Calculation, EnableEvents and so on)
- the subroutine code programmatically invokes the results of pivot tables included in a different worksheet in respect of the active worksheet
Unfortunately I can't figure out the reason of this supposedly strange behaviour.
Any help it would very appreciated
Regards,