Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared Workbook User had unsaved information disappear | Excel Worksheet Functions | |||
Shared Workbook - User Not Logging Out | Excel Discussion (Misc queries) | |||
audio alert when a shared workbook is saved by any user | Excel Discussion (Misc queries) | |||
Shared workbook: multiple user instances | Excel Discussion (Misc queries) | |||
Shared Workbook Settings, End User Update Changes Refresh Rate | Excel Discussion (Misc queries) |