ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   show time of Refresh button execution (https://www.excelbanter.com/excel-programming/404191-show-time-refresh-button-execution.html)

Irina

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



All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com