All,

I seem to have solved my problem with not being able to restrict th
workbook if its attribute is read only.....instead of using I
GetAttr(.Name)=1 Then Exit Sub i used the line I
ActiveWorkbook.ReadOnly Then Exit Sub. This seems quite neat as if th
original is opened again while already being edited then it will no
make another copy!

Thanks to all that replied and all those who are working on th
problem.

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=25742