PDA

View Full Version : Refresh All event



pulsar777
11-04-2019, 09:49 AM
Hi, I'd like to determine whether user clicked / used Refresh All excel feature, and only then run a Subroutine. I looked in libraries, checked Workbook and Application classes but nothing like Refresh All event there. How to do it ?

SamT
11-04-2019, 12:35 PM
Bump to better forum

Artik
11-05-2019, 11:12 AM
You can do this by monitoring the built-in ribbon controls:
http://www.vbaexpress.com/forum/showthread.php?65211-How-to-monitor-the-built-in-ribbon-buttons (http://www.vbaexpress.com/forum/showthread.php?65211-How-to-monitor-the-built-in-ribbon-buttons)
idMso="RefreshAll".

Artik