Hi, I'm trying to get some macros to combine data from two open workbooks, and I can't figure out the commands to switch from the active workbook to the other open workbook and back. I want people to be able to open, look-at and print the documents but not change them. The problem is that when I open my excel file it opens in read only format by default, but the properties is not set to read only, I already checked it. Can I do it with Microsoft? I've been browsing around for this option but have a feeling I might be asking the impossible. It seems to get a small way through the macro but then stop with no error messages or any sign that it hasn't completed properly.
I adapted the code in that other thread to this, Code: If Not ActiveWorkbook. I have made an excel file where other people have to go in and update it. You can then save this workbook for your records. If I log-in as someone else, I get the Read-Only Version. Even if you are not the author of a thread you can always help others by voting as Helpful. If someone attempts to make changes to a read-only workbook, the changes can be saved only by making a copy of the workbook and giving it a new name. Also See: I now have 2 excel spreadsheets i work from everyday, adding to them both and making them available to other work colleagues.
Thanks, Jason I did a bit of browsing on this problem. Therefore, anybody who really, really wants to could get access to your document. Does anyone have any idea what could have happened to this file?? How do I grant only specific people to be able to open, view, edit an excel file? Which may differ from the above directory. If you set a password to open the document the users will not be able to open the file without a password. This would display the following menu list Click on the Mark as Final menu, the following dialog box would appear. How can I do that? Excel will save the updated file as a temporary file and then remove the old and renaming the files.
Having a problem logging in? It would save me a couple days of work if it is possible. It allows data to be changed but not saved apart from allocating a new file name. But again, the second I save as. Now click on Owner tab in Advance Security Settings for User windows 6. Found others suffering the same but haven't found any conclusive answer yet. Note that the Allow Users to Edit Ranges command button is grayed out and unavailable if the worksheet is currently protected.
The file was originally created in Excel 2003 as an. I need for approx 20 users to be able to read-only a workbook but to allow only 2 users to make changes to the workbook. So I even made a about this. Doing this returns you to the Allow Users to Edit Ranges dialog box where the title and cell reference of the new range are displayed in the Ranges Unlocked by a Password When Sheet Is Protected list box. By not setting a password it will not prompt you for a password if you want to unprotect it. I've written a macro that is relatively simple.
Even if you are not the author of a thread you can always help others by voting as Helpful. When the file is opened, a message is displayed asking the user if they wish to open as read-only. The only thing I could suspect was I think this started around about the time I installed xlDennis' code library. Are you new to LinuxQuestions. See screen shot below: 5.
Is there a way to copy or save it as a different file that will not copy the password protection? I want users other then 2 people to open a particular file as read only I know the obvious answer would be to passoword protect the file and give the 2 people the password, however the file gets emailed into a server, which if I did that would prevent the server being able to open the file Anyone got any bright ideas please? I have done a search, for any file modified since Thurs and nothing has appeared. Now select the cells you want to make them as read only here I select cells of range A1:C18. Locate the file or folder on which you want to take ownership in windows explorer 2. Some days I can work without this problem, other days I encounter this 2 or 3 times. What modifications do I make to this to get this to work per above requirements? Set the file to read-only with a Macro By using a Macro, it is possible to set the file to read-only when the file is opened.
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! Thank-you I have searched and read all the help files. A Macro in this file creates a Copy of a specific Sheet within the Active Workbook and I want to Save it to the individual's Desktop. Any help is greatly appreciated!! In the Allow Users to Edit Ranges dialog, click New button. I have done this several times before. Pay attention to the use of upper- and lowercase letters because the range password is case-sensitive.
It appears that Excel 2010 will only allow the Author of the file to open an editable version; everyone else gets Read-Only. I am working with an Excel spreadsheet and saving it as a. Now, following this tutorial, you can get this operation done in Excel. Introduction to Linux - A Hands on Guide This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. Right click the sheet tab you need to make cell as read only, and then click View Code from the right-clicking menu. Locate the file or folder on which you want to take ownership in windows explorer 2. About 6 months ago this changed, even if I select edit workbook it still opens as read only.