How do you open a Workbook as read-only? I feel quite silly asking this Q, but Iv'e tried ActiveWorkbook.Open ReadOnly:=True in the Workbook_Open event and it debugs!!! In the help files they do not show examples of this. There is a property called .ReadOnly, but this only determines in a workbook is read-only or not!
I need the workbook to open read-only without the user needing to accept the prompt that comes from the Password to Modify option!