LinkBack URL
About LinkBacks
Hi,
I'm using this simple code to open any file from Excel (mostly Excel and Word):
Please Login or Register to view this content.
How do I set ReadOnly? The idear is not to make changes to the opened files.
Kind regards
Peter
Hi,
I'm using this simple code to open any file from Excel (mostly Excel and Word):
Please Login or Register to view this content.
How do I set ReadOnly? The idear is not to make changes to the opened files.
Kind regards
Peter
Hello Peter,
You can not set the the workbook "ReadOnly" property using a hyperlink. This can only be set using the Workbooks.Open method with its argument "ReadOnly" set to true.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
If you want to change the access mode of the just-opened workbook,
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
The document he is opening via hyperlink in the original post is a Word document.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Right:
My post is for the Excel files.to open any file from Excel (mostly Excel and Word):
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks