Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Read Only Icon (2007)

    I know this should be real simple but I can't find the answer.

    I want to create a desktop shortcut to open an Excel file as Read Only. I know it's just a matter of a or / and a letter but I just can't seem to find the right combination. I appreciate any help you can give me. Thanks.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Read Only Icon (2007)

    Create a new shortcut to Excel, right-click it and choose Properties, then in the Target box add this to the end:
    <code> /r Cathtoworkbook.xls</code>
    changing the path as appropriate.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Read Only Icon (2007)

    Perfect. Thanks Rory.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Read Only Icon (2007)

    That's a relief - I just assumed it would still work in 2007! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Read Only Icon (2007)

    It did, sort of.

    Here is the strange part, after I got your help yesterday, it worked on the first icon that I tried, I used the following in the target box:

    "C:Program FilesMicrosoft OfficeOffice12EXCEL.EXE" /r H:PlantProductionSchedule.xls

    Then I tried creating a different one, following the same pattern and it wouldn't work, until I put quotes around the file name, like this:

    "C:Program FilesMicrosoft OfficeOffice12EXCEL.EXE" /r "H:OfficeProductionHourly ScheduleManning Schedule.xls"

    Why it doesn't need quotes on one and then does on another, is beyond me. Fortunately these are the only ones that I need to set up this way, so if it works, I'm happy. Thanks again for the help Rory.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Read Only Icon (2007)

    The path and filename of the first workbook doesn't contain spaces, but that of the second one does, and that's why it needs quotes. Without the quotes, Excel will try to open "H:OfficeProductionHourly", which it can't find of course. For the same reason, the first part of the target is enclosed in quotes.

  7. #7
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Read Only Icon (2007)

    Thanks Hans, it's good to have it make sense.

Posting Permissions

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