Shared Workbook, automate existing data always wins

[Joe W.]

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

 

[Steve Dalton]

Hi Joe

Instead of this, have you considered using Excel VBA to access, via Outlook,
a shared calendar of some named individual, or made-up individual, to make
appointments? As I write this I'm not sure what the minimum Outlook
appointment resolution is and whether your 3 minute slot is too small. It
occurs to me that this might be more robust than the approach you are
currently looking at and would have the added advantage of enabling a
non-Excel user to see what appointments have been made. Alternatively, can
you do the whole thing in Outlook?

Regards

Steve Dalton