When a file is not available because another user has it open, I would like to have a Thisworbook open event that gives the option of saving a copy with the users name or the Computer name appended to it, and leaves the copy open.

Hope it's not much trouble.

Thank you much.