I've protected the sheet because it contains a lot of formula's. Our staff can't read and they keep opening additional copies of the file! Read this to understand more about the property. In essence, I want to do the same thing as setting the read-only bit for a file, but I want to do it for an Excel 2010 worksheet. Excel would not physically open the file and it is in a readonly state. I try my best to help everyone out, but sometimes I don't have time to fit everyone's questions in there never seem to be quite enough hours in the day! Open and Read Data from the Source File Next, I am opening the source Excel Workbook to read the data from it.
This will allow you to see everything but prevent you from clicking on any of the cells. I have run into the oddest errors with this. Now, if I want to run the output more than once, I get an message asking if I want to overwrite the existing file which I always do. It appears to work, but then when I try to have another user open the file, they are able to open the file, make changes to the file, and save the file with the same name. And you have to enter the password if you want to edit the file.
Your workbook is read-only now. However, is there a work around to allow a macro to save? To open the file as just read-only, click on the Read Only option. However, it would still be possible to use the keyboard to navigate around and edit the cells under the shapes. So, when you click on a read-only Excel file password protected to open it, Password dialog box will appear. Hi there, I have a piece of code called ConvertDates that formats data contained on 6 worksheets. I can't seem to locate the command button properties any longer.
However, when I close the file and re-open it the file is no longer read only. Click on the General Options. FollowHyperlink pdf End Sub So then I tried to create an instance of acrobat by setting a reference to the acrobat object but I can't get this to work either! You see there are two password fields in the dialog box. 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. When I reopen the file none of the buttons work.
Also, as mentioned above, Excel passwords are not secure. FileDialog msoFileDialogFilePicker 'Set the caption of the dialog box, fdl. Enter a password to make Read-only Passwords are not 100% secure Passwords entered using this method are not encrypted and can be cracked. Enter a file name and click Save. When I use the statement Code: ActiveWorkbook. The 6 data sheets all contain a data connection to a website of foreign exchange tables. I input a password in the Password to modify field.
If I use this code: With ActiveWorkbook If. . This is certainly more stringent than the non-password option. Constant or numeric expression, whose sum specifies file attributes. Many thanks in advance for your kind support. How can I prevent this message from popping up? Is it possible to write a macro that will start with the first file in a folder, open it and update links, run a macro, save and close, and open the next file in the folder until it has open all the files in the folder. Any ideas where I'm going wrong? The issue is the refreshes only happen if you step through the macro using the debugger.
Available only on the Macintosh. Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don't enter a password and check Read-only recommended. For example if the workbook contains product names and price data it can be hidden and you can show an Excel file that represents an invoice with drop downs for product that validates from that price list. Any help would be greatly appreciated. Ignore those errors at your peril - your application will eventually freeze or crash. Hello, I have a number of different files that I often need to run a macro on. To start viewing messages, select the forum that you want to visit from the selection below.
It is important that the password is only set for modifying the document. Is there a way to copy or save it as a different file that will not copy the password protection? Hi, I need the necessity do delete a sequence of sheets in my workbook. Please help and thank you! Alex: you are correct in your assertion, and I was incorrect in my above statement. In fact, thanks to default values, you can drop everything on that line after. This would speed up the macro code that I have written.
It will create a copy of each worksheet listed in a new workbook, then save and close the workbook. I don't mean a save. Every so often when I attempt to save a file, including save as , Excel won'r let me. It means: to make the read-only file editable, the user s must have the password. Is there a setting in Sharepoint that would make the file open as Read Only? Say I have an Excel file. Other suggestions on how to avoid this error? So does set attrib work in open workbook event to toggle between read only and read write? By won't let me I mean: using Save doesn't appear to do anything using Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed i.
How do I find out what the current User's desktop folder path is each time the Marco is run by a different User? After the code is executed Excel shows a message that the cell that was clicked was protected etc etc. I've tried turning off displayalerts but it's not working. They don't even seem to click. I was in a forum recently, when I came across a question on how to get or read data from a closed excel workbook file without actually opening it. It will save precious time too. UserName What if you need a secure read-only option? I have read about sharing the file and I don't think that would make things any better.