Warn a user in Shared workbook
 

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

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

Warn a user in Shared workbook
 

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



On 1 huhti, 17:56, JMay wrote:
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 asharedExcel 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 theshared
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