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 Sharepoint
I am maintaining an 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" is 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 (in VSTO) is false In the Add-in, how can I check whether the workbook is supposed to be read only? -- Many thanks, Gary Varga Re-posted as I had no valid responses (sorry PeterT - yours didn't count) and had logged in via an inactive MSDN account. |
#2
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 Sharepoint
"In the Add-in, how can I check whether the workbook is supposed to be read
only?" Do you mean that you want to try and determine when someone has attempted to open the workbook in Edit mode, but has ended up in Read-Only mode? I don't think that this is possible to do. You might like to read up on the ReadOnlyRecommended property of the Workbook object, but I don't think that it quite fits your situation. -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Gary Varga" wrote: I am maintaining an 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" is 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 (in VSTO) is false In the Add-in, how can I check whether the workbook is supposed to be read only? -- Many thanks, Gary Varga Re-posted as I had no valid responses (sorry PeterT - yours didn't count) and had logged in via an inactive MSDN account. |
#3
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 Sharep
No. Someone has opened it in read only mode and I would, programatically,
like to know this i.e. have they opened it read only??? "Alan Moseley" wrote: "In the Add-in, how can I check whether the workbook is supposed to be read only?" Do you mean that you want to try and determine when someone has attempted to open the workbook in Edit mode, but has ended up in Read-Only mode? I don't think that this is possible to do. You might like to read up on the ReadOnlyRecommended property of the Workbook object, but I don't think that it quite fits your situation. -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Gary Varga" wrote: I am maintaining an 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" is 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 (in VSTO) is false In the Add-in, how can I check whether the workbook is supposed to be read only? -- Many thanks, Gary Varga Re-posted as I had no valid responses (sorry PeterT - yours didn't count) and had logged in via an inactive MSDN account. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VSTO: Detecting Read Only status of workbook opened from Sharepoin | Excel Programming | |||
Programmatically determining if workbook is opened as 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 |