Can an excel sheet be set to close after 5 mins?

[DieArd]

HI peeps,

IN work we have an excel sheet which is shared by 12 managers on a shared place no the network, as you know only 1 person can edit at a time, but sometimes that person who has the sheet open forgets to close it and goes on dinner etc, when there screen saver comes on we cannot unlock it until they return to their desk..

Does anyone know of any way of coding that can be added to the sheet so that it will autmatically close after say 4 mins?

Thanks in advance for any replies.

 

[Jon von der Heyden]

Hi DieArd

It is possible to have multiple user edit a workbook. See here: http://office.microsoft.com/en-us/excel/HP052025951033.aspx?pid=CH010003631033

You may find this preferable over a macro that automatically closes the workbook after a few minutes.

Regards
Jon

 

[DieArd]

Hi DieArd

It is possible to have multiple user edit a workbook. See here: http://office.microsoft.com/en-us/excel/HP052025951033.aspx?pid=CH010003631033

You may find this preferable over a macro that automatically closes the workbook after a few minutes.

Regards
Jon

Thnks for that, I cant believe I didnt know that thanks again.