how to open files as read only from windows explorer
Oct 5, 2009 · At work we use group directories and its preferable to open files as read only so that others can access them for read-write purposes. I've figured out how to open files as read only …
How to purposefully open an Excel file as "Read Only"
Feb 10, 2010 · Do a variation of Sthrncali's suggestion and add a second Open button to my Standard toolbar in 2003 or my QAT in 2007/2010 that would display the open file dialog and …
Automatically Open as Read-Only without MessageBox
Oct 27, 2008 · Hi all, Is there a way to force a file to automatically open as read-only, without first warning the user? I have a workbook that I want a variety of users to be able to use. It is a …
How to open excel file in read only through the shortcut
Jun 8, 2016 · Hi! I have a file in the local network to wich i have a shortcut on my desktop. The thing is I usually want to open it in read only. Is there a way of doing it through the shortcut, …
VBA Macro to Open Read Only Excel from SharePoint and Enable …
Jan 9, 2018 · Hi all, I am currently in the process of trying to create a macro to run from my current workbook (file1) and be able to open an excel file from SharePoint (file2) to refresh and …
Help with VBA code - Open Files as read only and don't update links
Jul 24, 2019 · Hello, I have the below code and what it does is it goes through an entire folder and opens every excel file in that folder and performs a task on it. Unfortunately a good chunk of …
VBA: Open File as Not Read-Only | MrExcel Message Board
Sep 12, 2011 · In VBA, I want to automatically answer "No" to an "Open as read-only" prompt that pops up whenever I open a workbook. Is there a way to do this? I tried WorkBooks.Open …
Suppress Read Only Prompt | MrExcel Message Board
Aug 31, 2007 · This means that a number of users could have this file open at the same time Each user (after the first) receives the quite annoying popup window asking the user whether …
I want the file to open Read Only WITHOUT prompt - MrExcel
Apr 28, 2003 · I have a macro that opens up a file of forms, makes customizations, and saves each worksheet in that file as it's own form in the new project. It works great (self pat on the …
Excel not prompting that a spreadsheet is read only
Dec 21, 2009 · Are you finding that you can open the workbook and it's not read-only? It should say in the title bar [read only] and of course you should get a message on opening that this is so.