Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel thinks a file is ReadOnly but it is not. How to fix? | Excel Discussion (Misc queries) | |||
How do I use VC++6.0 to protect a excel file to readonly | Excel Programming | |||
How do I use VC++6.0 to protect a excel file to readonly | Excel Worksheet Functions | |||
Cancel Macro is user selects 'cancel' at save menu | Excel Programming | |||
Opening a ReadOnly file in Excel VBA | Excel Programming |