show time of Refresh button execution

I

Irina

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top