Hello,

I have a sheet at work that has several links to well over 100 word documents that I do not have permissions to. As it stands when these links are clicked a small window asking to select read only appears behind excel and excel appears to freeze until it is selected. The only way to switch to this window is using task manager, and I need this to be fool proof and usable by hundreds of employees.

I have seen many macros with Readonly=True for active workbooks, but have not come across any that will work for a .doc,

I have tried entering file paths individually with no luck.

I have tried something like this:


Set objWordDoc = objWordApp.Documents.Open( _
Filename:=objFile.Path, ReadOnly:=True)


No luck.

Please help!