Make Workbook ReadOnly
 

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

Make Workbook ReadOnly
 

ActiveWorkbook.ChangeFileAccess xlReadOnly


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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

Make Workbook ReadOnly
 

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