Also related to the shared workbook....
I have a sheet protected and a macro to sort the data on the sheet. The macro starts and finishes with unprotecting and protecting the sheet. Does unprotect not work in an shared environment? I do get an error 1004 referring to the protection of the sheet. In not shared mode it works fine.