Insert Hyperlink in word to an excel file that will open read-only when clicked?

1

To manually open an excel file as read-only I usually use excel /r "filename" on the command line, or just click file, open, open as read only from excel.

If I insert a hyperlink to an excel file in word, then clicking on it opens the excel file.

Is there anyway to insert a modified hyperlink in word that, when clicking it, would open the excel document as read-only?

Eliyahu

Posted 2015-07-17T12:20:23.893

Reputation: 465

2Are you familiar with VBA at all? This can be accomplished with a VBA macro, but I'm not sure it can be just with a modified hyperlink. – Ben Sampica – 2015-07-17T13:14:00.057

possible duplicate of Excel (2010) HYPERLINK: how to call a file with command line arguments and spaces in the path?

– Dave – 2015-07-17T13:15:52.137

@BenSampica I am familiar with VBA though only really with Excel.Not sure how to implement something like this is Word. – Eliyahu – 2015-07-20T14:15:28.483

Answers

1

Why not create a simple .cmd file and then hyperlink to it?

I just tested this:

C:\Program Files (x86)\Microsoft Office\Office15\excel.exe" /r "c:\users\7651\Downloads\book3.xlsx

Tara Frost

Posted 2015-07-17T12:20:23.893

Reputation: 76

Asked: 2015-07-17T12:20:23.893

Viewed: 2 248 times

Active: 2016-01-26T21:02:38.887