In EXCEL 2007 take the following action:-

Review

Changes group

Share Workbook

Remove the tick from the box called:-

Allow changes by more than one user at the same time. This also allows
workbook merging.

Hit OK.

If my comments have helped please hit Yes.











"Mike M" wrote:

I have a document shared. I need to record a macro and apply validation to
cells on the sheet. I must first disable sharing but just can't seem to find
it.