I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. I am running Excel 2011 for Mac. Confirm your password in the Confirm Password dialog box. What you cannot do is to group the data in a protected sheet using the outline tool. By reading this forum everyday! This will allow sorting to be performed on the protected worksheet.
Min 24, 112, 66, 4 Sheet1. I wish you the best of luck and I hope this tutorial gets you heading in the right direction! The default value is False. Regarding your questions: - Some of the code samples in the thread above do cycle through each worksheet in the workbook; so when run one time it automatically applies to all sheets in the workbook. So, bear that in mind as you deploy the book with the type of data in there. And, most importantly, share this with your colleagues. I have a Workbook with 2 sheets, the first one is the data entry and the second one contains all the calculations and confidential info.
Other actions may or may not be allowed by checking the various check boxes displayed above. Glad the code is working for ya. Since the macro cycles through and turns off protection, and then turns it back on again, you need a way to modify the macro code to include the additional protection attributes. I wish you the best of luck and I hope this tutorial gets you heading in the right direction! When the data is saved, I want the new excel sheet to be saved to a location specified within the macro so the user doesn't have any options and I want the title of the new file to be the value of one of the cells. If changes wanted to be made to a protected worksheet, it is possible to use the Protect method on a protected worksheet if the password is supplied. Be sure to update the code below to use the actual password you used to protect the sheets.
Problem is that I do not know if the sheet has existing grouping, or if it does, how many levels of grouping. Once I closed the entire workbook however, I noticed that I was not able anymore to add comments. Re: Allow Editing Objects On Protected Sheet Thank you for swift response Dave! Maybe my mistake was that I was clicking on Developer, then View Code, and pasting there. I susect from some of the earlier replies, others have encountered this same situation, but nobody followed back up with a solution if one was found. Can you please tell me the permanent code.
I have one more related problem you might be able to help me with. Afterwards, you can password protect your sheet manually knowing that the outlines feature will always be functional when sheet protection is enabled. Fortunately, it is very easy. Click on the box to remove the check mark so that group of cells will not be locked when you protect the sheet. Persisting the UserInterfaceOnly setting would be even more important imo. I want to allow people to autofilter the data in the worksheet but not modify the contents of the cell.
Remarks If you apply the Protect method with the UserInterfaceOnly argument set to True to a worksheet and then save the workbook, the entire worksheet not just the interface will be fully protected when you reopen the workbook. Protect Method - Protect Method as it applies to the Worksheet Object: This method Protects a worksheet so that it cannot be modified. I am new to Excel and I am creating fillable forms in excel which are protected so that users canonly input data in certain cells. Don S I have an excel 2007 file sitting in a shared network folder. The code you sent me is for earlier versions of Excel to be able to collapse or expand grouped data. Then, paste in the macro code. I can guarantee 9 times out of 10, one of my strategies will get you the answer s you are needing faster than it will take me to get back to you with a possible solution.
By Liam Bastick, Director with SumProduct Pty Ltd. I am sorry that we haven't answered you before now. This is my first foray into coding. They also want the words to wrap when they reach the end of the sentence. I'm concerned that changes will get over-written when 2 people are saving their changes.
To clarify: When you protect the sheet, the outline stuff doesn't work anymore. Appreciate any help, let me know if you have any further questions. This is accomplished by saving the macro code to the right spot. If however, you have few concurrent users, and they are mostly reading the workbook and not saving and merging changes, then it may work to modify the macro to actually turn off sharing, protect the sheets with outlining enabled, and then reshare the workbook each time it is opened. Is there a shorter way to handle this code-wise? Or any way to address this issue via some other method like adding a scrollbar,etc.
Send payment proof to 31 days after purchase date. Your advice is excellent and straightforward to understand. I can guarantee 9 times out of 10, one of my strategies will get you the answer s you are needing faster than it will take me to get back to you with a possible solution. A couple of versions ago was it 2002? For some reason it currently does not do this, and I have multiple users with the same doc open. The users told me that they do not want text to go beyond the edge of the page when they are inputting data. The one issue I have now, is that the other protection attributes that I had selected Format Cells, Format columns, and format rows get saved over by the default protection when the macro runs. Best regards, René Rene, Hi there! Then save the Workbook, close it, and reopen it, ensuring you enable macros.