Hello Bob, Hello okaizawa,

Thank you for your help. This works. I went without the fail-save-option as i
am controling the workbooks that are being processed and none would be
readonly to begin with. So it should not be an issue... if so, i'd confuse
the user one way or another anyway. ;-)

Thank you again.

Stefan

okaizawa wrote:
Bob,

Why bother testing if readonly, just set it
That is only an example.
If a workbook is readonly, "ChangeFileAccess xlReadOnly" fails.
(I use Excel 2000)



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200507/1