I am creating a Flu Shot Sign Up sheet in Excel 2007 that I want to allow
multiple people in our Intranet to use at the same time (Review tab, Share
Workbook, check Aloow Changes by more than one user...). Since I don't want
later visitors taking the time slot (every 3 minutes) of a previous visitor,
I already added code that prevents that, but because it is a Shared workbook,
I also need to allow first-come first-get rules. On the Advanced tab, I can
check either Ask me which change wins, or I can check The changes being saved
win. I want to always keep the first saved change, and thus always discard
(with notification) the later changes being saved. Any ideas how I can do
this?

I have thought that if I could check the Ask me which changes win, then
somehow have code that automatically manages the dialog that prompts the
user, but I don't know how to code for such an event. Ideas on this too?

-Joe