Save when cell is changed?

Is it possible to save a workbook whenever any changes are made to any cell in a specific column?

The reason - I'm putting an excel workbook out on a network drive for 4-5people to share. The sheet contains work items which are imported every 4 hours... Column A contains the status.

I want to save the file every time anybody changes a status to prevent multiple users from working on the same item.

I realize that I could build a form then load each workitem into the form, then apply the save to a change event on the field/control, but that's something for next week - I need to get this out the door, bare bones, as soon as possible.

Any help is greatly appreciated!

Put this macro into the SHEET MODULE for the sheet where you want this to occur:

Please Login or Register  to view this content.

Any changes in column A will immediately save the sheet.