MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Idle Autoclose Macro

  Asked By: Ava    Date: Nov 30    Category: MS Office    Views: 847

I am by no means an Excel VBA expert so please pardon any "stupid"
mistakes on my part.

Here is my problem.

I would like to implement a macro that automatically saves changes and
closes the workbook when the application has been idle for a set period
of time. I am having trouble even finding the components that I need to
write such a thing.

Can anyone help me?



1 Answer Found

Answer #1    Answered By: Ujala Hashmi     Answered On: Nov 30

Try a Google search for this - someone presumably has done it before.

However, excel  is not set  up to do this, so you'd need to keep track of
activity yourself. This means  that you'd have to trap several events
(probably cell and sheet focus change events) to make sure you didn't miss
activity, then have your timer check this before saving and closing.

I don't know if you're able to close Excel entirely in this way, but you
would be able to close the workbook.

Didn't find what you were looking for? Find more on Idle Autoclose Macro Or get search suggestion and latest updates.