Need a event for Refresh All

[sarsukanth]

Hi All,

i wrote a code and that need to be run when i press the Refresh All in Exce-2007. now i need to know that when i need to put this code means in which event.
please help me on this, i am very thankfull for that.


Raghukanth

 

[moonfish]

This page explains the use of BeforeRefresh and AfterRefresh queries:

http://support.microsoft.com/kb/213187/en

EDIT: This might not be the right kind of refreshing, please excuse me for posting before reading :P

 

[sarsukanth]

ThankU for responce, but i need a event to run my code when i press on Refresh All.

below answer is not working...