sethdromgoole
Programmer
Hi,
Does anyone know the VB code that will allow me to specify when a shared workbook is updated? I have built an application in Excel with userforms. The workbook needs to be updated when the user(s) navigate between various forms. I realize I can do this using the ActiveWorkbook.Save command; however, this is timely due to the writting to the disk. The Excel setting for automatic updates won't work because the minimum time is every five minutes. Any help would be greatly appreciated.
Thanks,
Seth
Does anyone know the VB code that will allow me to specify when a shared workbook is updated? I have built an application in Excel with userforms. The workbook needs to be updated when the user(s) navigate between various forms. I realize I can do this using the ActiveWorkbook.Save command; however, this is timely due to the writting to the disk. The Excel setting for automatic updates won't work because the minimum time is every five minutes. Any help would be greatly appreciated.
Thanks,
Seth