VSTO: Detecting Read Only status of workbook opened from Sharepoin

[Gary Varga]

I am maintaining an Excel VSTO3 Excel Add-in.
The Excel workbooks are loaded from SharePoint.
When you click on a workbook on the SharePoint site you get the option for
"Read Only" or "Edit".
When "Read Only" selected you:
a) get the "[Read-Only]" in the Excel caption for the workbook
b) get a Save As dialog box when clicking the Save button
c) the workbook ReadOnly property is false

In the Add-in, how can I check whether the workbook is supposed to be read
only?

 

[Peter T]

You can look at the ReadOnly property of the workbook

bReadOnly = wb.ReadOnly

Regards,
Peter T

 

[Gary Varga]

I DO.

As stated in my original post:

c) the workbook ReadOnly property is false

Thanks anyway.

 

[Peter T]

Apologies, I didn't read your post carefully.

Regards,
Peter T