Excel automatic save&close if inactive for 2 hours.

[FirefIy]

Hello.
I would like to know if this macros is possible? If it is, would you mind explaining what exactly I should be doing, because I'm a total newcomer when it comes to Excel's macros.
Thank you very much guys&gals.


Best regards,
Aleksey.

[nathansav]

Hi

It is possible, and you'll need to so some research on Application.OnTime. Basically, you'll set this to be 2hrs on opening, then cancel and reset on things like Sheet Selection Change or Sheet Change.

Cheers

[FirefIy]

Hi

It is possible, and you'll need to so some research on Application.OnTime. Basically, you'll set this to be 2hrs on opening, then cancel and reset on things like Sheet Selection Change or Sheet Change.

Cheers

Like I said, I'm really bad @ Excel marcoing, and when I try to do smth like this: http://www.biz-development.com/Softw...-Idle-Time.htm
It just does not work! I open the spreadsheet, go idle for a huge amount of time and nothing happens even tho the timer is set for 20 seconds, it kinda works if I hit Macros -> Reset (macro) and run it, but it just closes the spreadsheet in 20 seconds even tho I'm not idle.

[nathansav]

Do some research on the way i suggested then, Application On Time and the Worksheet Change events.

[satputenandkumar0]

Hi Aleksey,

Try below code in normal module.

Please Login or Register  to view this content.

In Thisworkbook module

Please Login or Register  to view this content.

[FirefIy]

Hi Aleksey,

Try below code in normal module.

Please Login or Register  to view this content.

In Thisworkbook module

Please Login or Register  to view this content.

Unfortunately your code does not work for me, I even changed the 02:00:00 timer to 00:00:20 (for testing purposes) yet absolutely nothing happens. Any idea what I did wrong? Here's a picture of what I've done:
oi58.tinypic.com/178i6b.jpg

[satputenandkumar0]

Dear Aleksey,

This is working. Try attached file I have change 25 seconds in it.