Warn a user in Shared workbook

[jari.toukkari]

Hi

In the network with a shared Excel file with 10 simultaneous users, I
would like to give a warning to a certain user when someone else
changes something in a column with his/her name, and saves the file.
Concerned person can easily see the change when looking at the shared
file, but there is normally other work going on and a warning would be
needed to "wake up" and react to the change. Warning could be like a
msgbox "There is a task opened for you", which you must "ok".

Any great ideas how to solve this?

Regards, Jari

 

[Guest]

Under Tools, Options, General Tab there is a field (near the bottom)
User Name (Box) - Do all your users have their names typed out therein?
If not this would be a good start.

Then - It would be a good practice to use the identical names from this box
within your data workbook, then you could "IMMEDIATELY-REFERNECE" when
a user (name) changed a field assigned to another user (name).

Just a First Thought - maybe someone else could agree or disagree before
moving on...

 

[jari.toukkari]

I propably solved this already.
I'll add autosave every 5-10 minutes to other software in the same
shared workbook. After each save changes can be seen and software can
compare username to the column heading name, and give a warning of
each empty cells. Bit complicated and someone will hate my autosave

It would be great to see the changes by other users without saving,
but propably that is not possible.

Br, Jari