Alan,
Maybe the SetAttr Statement

NickHK

"Alan" wrote in message
oups.com...
From within VBA how can I set the ReadOnly property for the
activeworkbook - setting the ReadOnlyRecommended property for the
workbook to True isn't sufficient for my requirements. Would I have to
drive Explorer to set the property or is there a way of setting the
XlFileAccess to 3 (the online help isn't very helpful!) - in either
case ... how?

Thanks

Alan