Hi,
I have tried different ways as listed on the Net but none of the macro that were given worked the way I wished. The macros execute the auto_close event after 30 minutes even if the there are activities on the workbook, which I am trying not to trigger the Auto_Close event. I could not figure out how to reset the timer to take effect only when there are no activities.
I thought about the Worksheet_Change event but did not know how to reset the timer.
Can any one help me achieve it.
Regards,
Chuck
I have tried different ways as listed on the Net but none of the macro that were given worked the way I wished. The macros execute the auto_close event after 30 minutes even if the there are activities on the workbook, which I am trying not to trigger the Auto_Close event. I could not figure out how to reset the timer to take effect only when there are no activities.
I thought about the Worksheet_Change event but did not know how to reset the timer.
Can any one help me achieve it.
Regards,
Chuck