Warn a user in Shared workbook
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...
" wrote:
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
|