Shared Workbooks - Overwriting issues

[Jay3]

Hi All,

I have a shared task list which can be updated by multiple users.

The problem is if more than one user is using the spreadsheet at any one time you run the risk of someone opting to enter a task on the same line.

This will mean that someones task may be overwritten.

My spreadsheet generates an email notification when a new task is added and saves the spreadsheet each time.

The problem is, however, when a user saves the workbook the workbook doesn't automatically update for the other users each time. They have to manually hit save before the enter a new task to refresh the spreadsheet.

Is there a way around this?

Thanks,
Jay3

 

[pbornemeier]

Fill a few dozen lines below the current list with a solid color, so no one will type in them.
Have new tasks entered on a separate worksheet. Have the BeforeSave and BeforeClose events check to see if a new task exists on the input worksheet. If one or more new tasks are present, have code execute that removes the fill from the line(s) below the list and moves the new tasks to the bottom of the current list.

Although this won't update each open copy of the file, it will prevent then overwriting you mentioned.

 

[Jay3]

Thanks )