DoctorV wrote:
[snip]
ActiveWorkbook.SaveAs Filename:=filespec
f.Attributes = 1
ActiveWorkbook.Close
[snip]


Untested but could it be following?

after you use saveas you have to close it first,
and THEN change the readonly property of the file.

(it's not the user's lock that's bothering you,
it's your own :-)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool