I have a macro that saves a workbook (locally, and a second time to the
network shared file).

Can I have two cells on the sheet that are (say) Red if the workbook has
unsaved changes, and Green if it has been saved?

Thanks

RobL