ActiveWorkbook.SaveCopy as Filename with attr set to read only

[David Evans]

Anyone know how to set the file attributes to Read Only when you use the above command? or any other workarounds for it?

Thanks

 

[Luke M]

Do the normal SaveCopy to create the file, and then go back and change it's settings is what I would suggest.
http://www.mrexcel.com/forum/excel-...-write-attribs-visual-basic-applications.html

 

[David Evans]

SetAttr "Filename", vbReadOnly after the initial line to write the Filename does the trick ...