VSTO: Detecting Read Only status of workbook opened from Sharepoin
 

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?
--
Many thanks,
Gary Varga

Detecting Read Only status of workbook opened from Sharepoin
 

You can look at the ReadOnly property of the workbook

bReadOnly = wb.ReadOnly

Regards,
Peter T

"Gary Varga" wrote in message
...
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?
--
Many thanks,
Gary Varga

Detecting Read Only status of workbook opened from Sharepoin
 

I DO.

As stated in my original post:

c) the workbook ReadOnly property is false

Thanks anyway.

Detecting Read Only status of workbook opened from Sharepoin
 

Apologies, I didn't read your post carefully.

Regards,
Peter T

"Gary Varga" wrote in message
...
I DO.

As stated in my original post:

c) the workbook ReadOnly property is false

Thanks anyway.