Determine current active users in Excel shared Workbook

[s300570]

Hi,

I have a shared workbook, and need to save a backup copy of it when the last active user get's out. So it's possible to determine how many users have a shared workbook open, and if the current user is the only user, in order to put a code on Workbook event Close/Deactivate to save a copy of it?

Thank you guys in advance.

My best regards

Leopoldo Fernandes
Lisbon - Portugal