If you have checked “ Read-only recommended” in MS Excel, then every excel workbook you create later would be checked by default. But when you save and open this workbook next time, you would find this workbook still recommend you to open it as read only. You can change workbook and save changes this time. Select “ No” and excel workbook would not be opened in read only mode. To save changes, you just could create a new copy of the workbook and give it a new name, or save workbook in another location. Then changes cannot be made to the original workbook. Select “ Yes” and workbook would be opened in read-only mode. But they still have choices to open workbook as read only or not. Tap on “ Save” button and save excel workbook to replace that already exists.įrom then on, when other people open the excel workbook, they will be prompted that the excel workbook should be opened as read-only unless they need to save changes to it. Check “ Read-only recommended” in following General Options dialog. Click File > Save As in Excel, then in Save As dialog, select Tools > General Options.Ģ. Way 2: Mark Excel Workbook “Read-only recommended”ġ. So even though it could help to set excel workbook read only, it still cannot prevent people from editing. If you want to remove it, you just need to select “Mark as Final” option in File > Info > Protect Workbook again. But actually the option “Mark as Final” would just make readers know the workbook is read-only. Then a message would prompt you that the settings would turn off typing, editing commands and proofing marks. Click “OK” on pop-up dialog to make sure this workbook will be marked as final and saved. Navigate to File > Info, click Protect Workbook and select Mark as Final in several options that you can use to protect your workbook.Ģ. Way 1: Set Excel Workbook Read Only by “Mark as Final”ġ.
Way 3: Set modify password to protect Workbook in read only mode.Way 2: Mark Excel Workbook “Read-only recommended”.Way 1: Set Excel Workbook read only by “Mark as Final” option.
If you have no idea about how to set excel workbook read only, following article would tell you several ways that you can use to restrict other people from changing your workbook. If the file has been opened for sequential input or output, Lock and Unlock affect the whole file, regardless of the range specified by FromRecord and ToRecord.Whether you want other people to edit your excel workbook without permission? If not, then setting your excel workbook read only is a common but good method for you to choose. Static member Lock : int * int64 * int64 -> unit Public Sub Lock (FileNumber As Integer, FromRecord As Long, ToRecord As Long) Parameters Public static void Lock (int FileNumber, long FromRecord, long ToRecord) static member Lock : int * int64 * int64 -> unit Static void Lock(int FileNumber, long FromRecord, long ToRecord) public static void Lock (int FileNumber, long FromRecord, long ToRecord) The My feature gives you better productivity and performance in file I/O operations than Lock and Unlock. FileOpen(Int32, String, OpenMode, OpenAccess, OpenShare, Int32)Ĭontrols access by other processes to all or part of a file opened by using the Open function.If the file has been opened for sequential input or output, Lock and Unlock affect the whole file, regardless of the range specified by FromRecord and ToRecord. If Record alone is specified the single record will be locked/unlocked. If Record, or FromRecord and ToRecord are not supplied, the lock will be for the whole file. The arguments to Lock and Unlock must be identical. Lock and Unlock functions are always used in pairs. The Lock and Unlock functions are used in environments where several processes might need access to the same file. Sub PutInLockedFile(ByVal onePerson As Person)įileOpen(1, "c:\people.txt", OpenMode.Binary) This example assumes that People.txt is a file that contains records of the structure Person. This example illustrates the use of the Lock and Unlock functions. In this article Overloads Lock(Int32)Ĭontrols access by other processes to all or part of a file opened by using the Open function. Controls access by other processes to all or part of a file opened by using the Open function.