Automatic close

[krishnaa_kumarr88]

Hi,
Does anyone knows how to close the workbook automatically if it is ideal for 5 mins .

[HansV]

I assume that you mean 'idle' instead of 'ideal'.
Please define exactly and in detail what you mean by 'idle'.

[krishnaa_kumarr88]

sorry. Yup.
Its Idle not ideal.
If user forget to close down the excel and left idle for 5 min , i would like to auto save and close excel automatically so that other users in the network can open the same file if they want to

thanks

[HansV]

What do you mean by "left idle for 5 min"? Please define EXACTLY and IN DETAIL what you mean!

[krishnaa_kumarr88]

I have mutliple team members using one spreadsheet and on the chance someone goes to lunch and leaves the spreadsheet open, no one else can't be accesssed.

What I need is a macro that autosaves the shared workbook, then closes it if left idle for a period of time (say 5 mins).( For your information: I would like to autosave and close the shared workbook )

Any help would be appreciated.

[Rudi]

Found this macro that seems to fit the bill...

Follow the instructions and give it a test.

[HansV]

What if the user is filling in a userform? During that time the workbook itself may be "idle", so it would be closed after 5 minutes...

[krishnaa_kumarr88]

hmmm Hans, i think you are right.
I either want my excel spreadsheet to make it as shared workbook other wise i should set timer to close the excel automatically to allow other users to use .
hmmm. any idea?
thanks

[HansV]

I assume that the workbook will be used by multiple users within the same office. If user A keeps the workbook open and user B wants to use it, can't B ask A (in person, or by phone or e-mail) to close it?

[krishnaa_kumarr88]

hmm thats sound good idea... thanks