Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.sharepoint.portalserver.development,microsoft.public.excel.programming,microsoft.public.office.developer.com.add_ins,microsoft.public.sharepoint.windowsservices.development
|
|||
|
|||
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 |
#2
Posted to microsoft.public.sharepoint.portalserver.development,microsoft.public.excel.programming,microsoft.public.office.developer.com.add_ins,microsoft.public.sharepoint.windowsservices.development
|
|||
|
|||
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 |
#3
Posted to microsoft.public.sharepoint.portalserver.development,microsoft.public.excel.programming,microsoft.public.office.developer.com.add_ins,microsoft.public.sharepoint.windowsservices.development
|
|||
|
|||
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. |
#4
Posted to microsoft.public.sharepoint.portalserver.development,microsoft.public.excel.programming,microsoft.public.office.developer.com.add_ins,microsoft.public.sharepoint.windowsservices.development
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programmatically determining if workbook is opened as Read Only | Excel Programming | |||
Hide Custom Command Bar if Workbook opened Read-Only | Excel Programming | |||
Not Detecting Open Workbook Status - Odd?? | Excel Discussion (Misc queries) | |||
How do I clear read-only status on a workbook file? | Excel Discussion (Misc queries) | |||
How to read sheet of currently opened workbook | Excel Programming |