Thanks in advance It's not the only option - it is a possible option in light of the fact that we don;y know how your network is set up. Once you are satisfied that all the users can run their files successfully over a period of time and you have done a few manual consolidations then we can talk about automating the consolidation. Im not ure need advice. Remaining parameters are optional arguments. Worksheets SheetName Any suggestions gratefully received! Re: Redefining A Workbook As Read Only Upon Opening Hey Tom, Thanks for the tip. When the read-only file is password protected You cannot directly disable the read-only option from an Excel file if the file is password protected.
It is also coming up read-only i dont know if these two things are connected or not. Text Dim objExlApp As Excel. In the image above, select a Folder where you want to save your Excel file. After selecting a folder, you will get the Save As dialog box as the picture below. Click on the Tools button and click General Options. It represents the file name of the Workbook. The user must open the file as read-only unless they have the password.
ChangeFileAccess Method See AlsoApplies ToExampleSpecificsChanges the access permissions for the workbook. I need to make macro enabled workbook to be readonly for All except admin Also admin has a cmdbtn to click which asks for password, and if successful then file should be set to readwrite property. Click the button on the top left corner of current worksheet to select the whole cells. Ignored if there's no password for the file or if Mode is xlReadOnly. It yields some interesting dialog boxes under certain circumstances. Just click on the Save button and save the file.
Your workbook is read-only now. Application Dim xlSheet As Excel. In this dialog box, click on the Read-only recommended check box. Hi If user remove readonly from the file property i want do something like this. This served as a good check and also prevented a bunch of confusion. My macro wont save properly and is coming up read-only.
User Alert System provided by - Copyright © 2019 DragonByte Technologies Ltd. It returns the opened workbook as read only. Chances are this post did not give you the exact answer you were looking for. Now, I want to make this file Read Only. Save but the file is on a local drive and it wont save to different computers when i try to pull it up. But now users want to be able to do the imports unattended and I cannot find a way for Access to open the files as read-only so as to avoid any dialogues.
UserName What if you need a secure read-only option? How do I automatically tell it not to save changes before switching modes? Press the Ctrl + 1 keys simultaneously to open the Format Cells dialog box. It is part of workbooks collection. To start viewing messages, select the forum that you want to visit from the selection below. I have tried saving the file as Excel 2003 and saving it to my desktop, to see if it is the version of Excel, or my folder permissions, but neither works. If you want to save the workbook, you need to save the workbook with a new name or in a different location. This is certainly more stringent than the non-password option.
Instructions to use Macro Here are the instructions to use above macro procedure in Visual basic editor. If you select the No option, the file will be opened in editable mode. Specify and confirm your password to protect the worksheet as below screenshot shown. The ChangeFileAccess method still does some funky things, potentially. Then sheet A1 is opened and non editable. Specifies the write-reserved password if the file is write reserved and Mode is xlReadWrite. And you have to enter the password if you want to edit the file.
Thanks Change file access method wasn't reliable, tried with few users on network drive, all in readonly mode on opening file, and only one user to go readwrite. In this case, anyone else can only open a read only version until the first person closes theirs. Press the Alt + Q keys to close the Microsoft Visual Basic for Applications window. When you click on the file for opening, Password dialog box will pop up. The file will be opened, but not as read-only.
This may require an updated version to be loaded from the disk. Hi All I have a file that is saved as read only using the below steps to achieve this. You may have to before you can post: click the register link above to proceed. The part where it potentially Re-Opens the file from disk has me very concerned, for my application. The dialog box has some information for you. It will create a copy of each worksheet listed in a new workbook, then save and close the workbook.