Shortcut that forces Open in Read Only mode

Posted on 2005-04-18
Last Modified: 2008-02-20
Can I create a shortcut to a document/spreadsheet that forces it to open in a Read Only mode?

 - this is for a shared contacts spreadsheet that all users can access, but it would be nice if the shorcut to it opened it in Read Only so that if it's ever opened for REAL changes (via another shortcut, or just Explorer) then it can be edited easily without having to kick any other users out.  

Ideally a desktop shortcut.  Don't really want to mess with perms on the file, as all users may eventually need to edit it, and being locked out forever would just confuse them.  Aw Bless....

cheers, Danny
Question by:DanCh99
    LVL 16

    Expert Comment

    Do a search in Excel help for this
    "customize how excel starts"
    LVL 16

    Accepted Solution

    Open a specific workbook as read-only (read-only: A setting that allows a file to be read or copied, but not changed or saved. If you change a read-only file, you can save your changes only if you give the document a new name.)
    /r workbook path\file name
    "c:\program files\microsoft office\office10\excel.exe" /r "\\server\share\exceldocument.xls"
    LVL 23

    Author Comment

    superb.  I'd totally forgotten that switch.  

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Can I legally transfer my OEM version of Windows to another PC?  (AKA - Can I put a new systemboard in my OEM PC?) Few of us are both IT and legal experts but we all have our own views of Microsoft's licensing rules and how they apply.  There are…
    There are 2 things you must have in order to connect to the internet behind a router, The "Gateway IP" of the router, which is usually something like, I've seen routers with default values of:,,, …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now