+ Reply to Thread
Results 1 to 4 of 4

Edit ReadOnly:=True word doc

  1. #1
    Registered User
    Join Date
    11-04-2004
    Location
    Athens
    MS-Off Ver
    2019
    Posts
    48

    Edit ReadOnly:=True word doc

    Hey all,


    So i got a word doc in onedrive where i am the author.

    when i manually open the file with r-click, open as read only then i can not edit the file contents.

    but, when I open the file in readonly mode from a workbook with vba like this
    Please Login or Register  to view this content.
    word lets me edit the file but ofcourse does not let me save. which is actually what i need, so all good so far.

    but when another user opens the file with the same code, word does not let them edit the file as opposed to my case!

    if both users open the file without ReadOnly:=True (vba or manually) then both users can edit/save the file.

    I tried making the 2nd user author as well but they still can't edit the file when in vba, ReadOnly:=True.

    Any idea how i can make both users edit the file when opened with vba, ReadOnly:=True (and not be able to save)?


    thx!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,430

    Re: Edit ReadOnly:=True word doc

    You have posted in the Excel forum section - shall I move your thread for you?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    11-04-2004
    Location
    Athens
    MS-Off Ver
    2019
    Posts
    48

    Re: Edit ReadOnly:=True word doc

    well im trying to acchieve this from within an excel workbook vba but sure if you think there is a more appropriate section

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,430

    Re: Edit ReadOnly:=True word doc

    Oh, my apologies - I misread the opening post!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Workbooks.Open (Readonly:= true) fails at random times
    By wannabeNerd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2015, 03:53 AM
  2. [SOLVED] Open workbook if not readonly. If readonly try again.
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2014, 02:45 PM
  3. I need to edit my formula so it displays every second true result
    By PatAlex in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2013, 07:19 AM
  4. True Word match
    By olds2k in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-02-2013, 11:26 PM
  5. True Word Count
    By VegasL in forum Excel General
    Replies: 4
    Last Post: 09-26-2011, 01:30 PM
  6. Edit the value of a cell that has the formulahidden set to true?
    By Wizz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2009, 05:06 AM
  7. [SOLVED] How do I stop Excel from changing the word true to TRUE?
    By Schmyerlou in forum Excel General
    Replies: 1
    Last Post: 11-23-2005, 05:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1