LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default How to use Excel VBA to cancel Excel readonly status

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel thinks a file is ReadOnly but it is not. How to fix? Don Berman Excel Discussion (Misc queries) 1 March 27th 08 05:42 PM
How do I use VC++6.0 to protect a excel file to readonly gowinder Excel Programming 2 September 22nd 05 02:18 AM
How do I use VC++6.0 to protect a excel file to readonly gowinder Excel Worksheet Functions 1 September 22nd 05 02:16 AM
Cancel Macro is user selects 'cancel' at save menu Mark Excel Programming 1 April 6th 05 05:45 PM
Opening a ReadOnly file in Excel VBA Demon Excel Programming 4 August 8th 03 04:06 AM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"