Macro to save and close an excel spreadhseet if idle

Dear All,
I have a shared spreadsheet used by different people and there is a chance that someone leaves the spreadsheet open and no one else can't be accesssed. What I need is a macro that save the workbook and then closes, if left idle for 2 mins. The thing is that I am already using some macros in the spreadsheet and I don't know how to incorporate the same. Attached the file for reference.

Thanks in Advance.

Jefy

Good morning jefyninan

Have a look at Allen Wyatt's code here.

The only change you'll need to make to fit it in with yours is the Workbook_Open module, which will need to read :

Please Login or Register  to view this content.

Everything else can remain unchanged. You won't need to use his Workbook_Open code - the above will handle it.

HTH

DominicB

Sir,

I have got very little knowledge about the vba coding. Whatever in the attachment is helps received from colleagues and internet. Could you please help me incorporating the same to my sheet...(if possible??)

Thanks

Hi jefyninan

Currently set for 1 minute, due to this line :

Please Login or Register  to view this content.

in the SetTimer module, in Module2 - this is in hh:mm:ss format. Change to whatever suits your needs.

I also fixed another error that occurred on opening.

HTH

DominicB

Hi Dominic,
I checked the file and noticed these two issues:
1. Its not saving the data automatically, after the set time.
2. The first two columns (:Sl. No" & "Date") were locked and dont want the users to edit the values.
Hope you can fix this too....Many thanks!!

jefy

hi jefyninan

Now fixed.

HTH

DominicB

Hi Dominic,
Thank you so much for your great efforts.
Its now working as per my needs!!

Jefy