View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Irina Irina is offline
external usenet poster
 
Posts: 12
Default show time of Refresh button execution

Hello all,
I use Excel 2007 and want to write a macro that does the following:
1. when user presses Refresh button (its on the Data ribbon) starts the timer
2. optionally it shows the timer in one of the cells and updates the time
3. when refresh command is done stops the timer and shows amount of time it
took to refresh the spreadsheet.
Thank you,
Irina