+ Reply to Thread
Results 1 to 3 of 3

Disabling option to open file as read only

  1. #1
    Registered User
    Join Date
    09-06-2013
    Location
    Northamptonshire, England
    MS-Off Ver
    Excel 2003
    Posts
    45

    Disabling option to open file as read only

    Morning all,

    I have just finished making a document and would ideally like to stop users opening it in read only mode.
    When the file is already in use, the second user is prompted to open the file as read only. Is there a way to remove this option and instead tell the user that the file is already in use and then simply close the document down?

    Thanks!

  2. #2
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: Disabling option to open file as read only

    Place this code in the "ThisWorkbook" Module
    Please Login or Register  to view this content.
    If your questions has been answered to your satisfaction please don't forget to do the following:

    Add Reputation ... and ... Mark Thread as Solved

    Thanks,

    Ma 10:8b Freely you have received; freely give.

  3. #3
    Registered User
    Join Date
    09-06-2013
    Location
    Northamptonshire, England
    MS-Off Ver
    Excel 2003
    Posts
    45

    Re: Disabling option to open file as read only

    Excellent! Quick fix. Thank you

+ 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. Disabling the message boxes of another file that will open when Macro executed
    By mr_horhe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2012, 06:04 AM
  2. Macros are working even when I open the file disabling them
    By Jhertilus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2012, 03:34 PM
  3. Read a text file from a central location or create a dll. What's the best option ?
    By kapilrakh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2012, 01:56 PM
  4. Skip The Read Only Prompt When I Open A File - Excel, Open it read-write instead.
    By harry_1805 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2012, 02:14 AM
  5. Macro to remove the option to save as if file was open as read only?
    By extremecorvette in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-17-2011, 03:40 PM
  6. Replies: 0
    Last Post: 03-03-2010, 12:21 PM
  7. read-only option not appearing on file menu
    By marnie in forum Excel General
    Replies: 1
    Last Post: 09-21-2007, 12:04 PM
  8. [SOLVED] disabling linked object before you open a file
    By totoro in forum Excel General
    Replies: 4
    Last Post: 08-12-2005, 02:05 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