Changing the workbook file access is attempted through the workbook
ChangeFileAccess method. Of course, if there are restrictions on the
server, etc., it will fail.

--
Jim
"kobeting" wrote in message
...
| Dear All,
|
| Recently, I have developed an Excel VBA for my internal users. In this
| VBA, user can press a button to save the workbook immediatedly.
|
| Now, I have placed this Excel file onto our SharePoint website for
sharing
| to the public. However, I have realized when the user open this Excel
file,
| it will be in Readonly status. User can open it but they can't save data
in
| this Excel (through marco).
|
| I would like to ask that are there any coding can change the Excel
| workbook from readonly to read-write status, so the user can save the
data?
| Otherwise, any other codes can help me to save the Excel without any
notice
| for the user in SharePoint website?
|
| Thank you for all