• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1339
  • Last Modified:

Shortcut that forces Open in Read Only mode

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
Danny Child
Danny Child
  • 2
1 Solution
Do a search in Excel help for this
"customize how excel starts"
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"
Danny ChildIT ManagerAuthor Commented:
superb.  I'd totally forgotten that switch.  

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now