![]() |
Workbook_sheetChange event
I have a spreadsheet with some code that I need to run every time something
changes in my workbook. I can do this through the sheetChange event and it works fine except for the fact that the spreadsheet runs very slowly when a user makes a lot of changes in a short amount of time. What I am searching for, is a way to run my code only when there haven't been any changes in the last 5 seconds. Ex: If a user makes a change a 0sec then my update code will run at 5sec If a user makes a change at 0sec then another change at 4sec then my update code will only run once at 9sec. Any ideas of how to accomplish this in excel? maybe using custom events in a interesting way? |
All times are GMT +1. The time now is 03:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com