Include a or use the website to generate the reddit table markup from your spreadsheet. I included a screenshot below for reference. I didnt believe that this would work. This is slighly above my paygrade. Say, once a workbook is shared, it prevents worksheet protection from being changed or turned off, either manually or via a macro. It looks like you have received a response on your questions.
Step2 Select any cells you do not want protected. This message is auto-generated and is not monitored on a regular basis, replies to this message may not go answered. I saved the file as. How to allow sorting and Filter locked cells in protected sheets? I ran the macro I had modified for the user and sure enough it worked. Please let me know if that is what you needed, or, if I can help further with this one. I'm currectly using the following code to protect my sheet: ActiveSheet. B5 quote: Why not put the data on a separate worksheet and protect that.
Then, paste in the macro code. Protect End Sub '---------------------------------------------- 6. Change ActiveSheet Protection Settings Here is the code you will need to run to enable the outline buttons to work on your currently selected spreadsheet tab. Send payment proof to 31 days after purchase date. I could not perform that action.
Protect method itself, not in some separate field. May not always work, especially if the file is corrupt, because the Application controls its functionality! What the macro does is that each time the workbook opens, it temporarily turns off worksheet protection, then it turns it back on and enables the user to interact with the group buttons. So, in effect, the user can delete rows where there are no locked cells. Grouping can be taken to eight levels, viz. Dave Peterson thanks agin Dave posted the following and it worked fine for me.
Am I suppose to name the code above as a macro and then run it each time? Can you help with the following. Afterwards, you can password protect your sheet manually knowing that the outlines feature will always be functional when sheet protection is enabled. Thanks, Jeff Robin, Hey, thanks for sharing the updated code!! Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. If you're new to macros, you may want to read David McRitchie's intro at: ' Dave Peterson 12. Then press F5 key to run this code, and a prompt box will pop out to remind you entering the password to protect the current worksheet.
I was able to get it to work now. Please help on this issue Thanks Arun, Overall, it sounds like the solution is to ensure that the macro automatically runs each time the workbook opens up. Stumped The workaround would be to write a macro to disable sharing of the workbook, turn userinterfaceonly back on and reshare the workbook again. Caveat emptor — it is provided in good faith and should work for most readers. Groups can be expanded or collapsed in protected worksheets using the code snippet shown below. I am using the code for enabling all worksheets for Grouping on a protected sheet that you offered in the original inquiry. Kutools For Excel Brings 300+ Advanced Tools For Solving Work Scenarios, Helps You Solve Excel Puzzles.
I believe it does what you want. As an alternative the code could be executed when a worksheet is activated using the event. I've tried to look everywhere through many excel forums but couldn't find an answer to this. I want to be able to protect the sheets, to protect some formulas and such from user intervention, but it seems there's no way to do that and still allow the user to expand or collapse the Grouped columns whenever they want. You cannot even expand groups on a protected worksheet.
. Thus, if you have lots of concurrent users, and they are all editing not just reading and merging changes, I can't think of a workaround. I was thinking the same thing when I found this. One approach is to create a macro that the user can run, perhaps via a button on the worksheet, that will perform the grouping on the active rows. Open the Visual Basic Editor, drill into the Microsoft Excel Objects folder, and double-click ThisWorkbook.