This one worked fine for me Barry-Jon, many thanks.

Vaya con Dios,
Chuck, CABGx3

"Barry-Jon" wrote:

I am not aware of a built-in way of telling if the workbook is already
open by another user or not. You could however only run the code if
the workbook has been opened for editing (e.g. is NOT read-only) as if
someone else already has it open then they would have had to open a
read-only version? In that case you could wrap your code in an "if not
me.readonly then" block.