Hmmmm.....

Does anyone know if I am on the right lines wit
AutoUpdateSaveChanges?

From good old help....

"This example causes changes to the shared workbook to be posted t
other users whenever the workbook is automatically updated.

ActiveWorkbook.AutoUpdateSaveChanges "

Any idea if this will update remote users when a manual save happens?

Gonna give it a try......

--
Message posted from http://www.ExcelForum.com