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 ?
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 ?
Bump to better forum
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
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
idMso="RefreshAll".
Artik
Posting Permissions
Reply With Quote
