Consulting

Results 1 to 3 of 3

Thread: Refresh All event

  1. #1

    Refresh All event

    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 ?

  2. #2
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,056
    Location
    Bump to better forum
    I always expect the student to do their homework and find all the errrors I leeve in.

    Please take the time to read the Forum FAQ

  3. #3
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    311
    Location
    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

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •