This can do, but I would like to get rid of the pop- up if possible. Step 1: Make cells editable so that sorting will work. Re: Sort protected worksheet Regardless of my opinion re: Microsoft' s implementation of the UI functionality is there a way to sort a protected sheet? Browse other questions tagged excel vba excel- vba sorting or ask your vba own question. When you turn protection on you can choose to allow all users to Filter, to Sort.
I' ve checked both of these boxes. Problem with sorting data on a protected sheet. The sheet MUST be protected as it is the one sheet with all the data that feeds the other 160 tabs. October 1, Stephanie Rosario. I click on the country column header arrow select UK , I get vba a pop up with the list of all the country in the column boom I have a filtered list. How to Sort Data in Excel using VBA ( A Step- by- Step Guide) Excel already has a couple of ways to sort data quickly. Re: Protect sheet with VBA Code BUT allow autofilters Dave - I just was playing around realized that if I just click cancel vba on the password pop- up the macro works. Sorting on a protected Excel sheet.
Sep 20, · Adding a password to the protection is possible with VBA. Vba sort protected sheet. com October 24 at 9: 12 pm - Reply I have written about how to protect un- protect a Sheet in vba a Workbook. is there any method to sort it. ” This allows users to vba edit these cells when the worksheet is protected, even vba if they are locked cells. Add cells we want to sort by a range and make that range editable in “ Allow Users to Edit Ranges. Re: VBA Sort not working on protected sheet Well I can filter with no problem.
Feb 14 · Sort isn' t working on protected sheet I have a table of data with the auto- filter turned on. Get Tables working on protected sheets ( add rows filter, sort etc. i have an vba excel related problem. I want to protect the vba worksheet. Unprotect the sheet you are working on; Right- click the cell, select.
Re: Sorting a table in a protected sheet when some cells are locked. ) I would like to be able to under the right circumstances have the ability to add/ remove rows of a table which resides on a protected sheet. Autofilter is set before protection I tick to allow users to Sort , , when protecting to Use Autofilter. In this article I am going to cover all about protecting unprotecting a [.
I try to sort by ascending or descending to be faced with " The cell or chart you are trying to change is protected and Sorting a locked table on a protected sheet with VBA - Page 2 Help. Jan 29, · To be clear, my protected and unprotected cells/ columns are non- contiguous - protected, unprotected, protected, unprotected, etc - and I need to sort the entire worksheet ( or at least the entire table), where the user can specify any combination of columns and other sort criteria. Feb 17, · Re: Data Sort with Protected Worksheet When you are protecting a sheet you state what a user will be allowed to do. One of the options is " sort". Try unprotecting the sheet and protecting it again allowing sort by clicking on the sort checkbox that is a little bit further down on the list.
vba sort protected sheet
If as you say, you want code to allow a sort on a protected sheet, then something will need to trigger the code which allows you to do the sort. Since you want to have the sort buttons be the trigger, then one option is to customize your tool bar with a sort macro ( including the unprotection and reprotection code) that is assigned to those buttons.