Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I allow users to sort a protected table using dropdowns?
I'm trying to create a table where users can't edit the content of the cells
but can edit the ordering of the table- what's the best way to achieve this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I allow users to sort a protected table using dropdowns?
Stuart,
I've written this code some time back for one of my users and it works perfectly for them. Maybe you would like to adapt to suit your needs.. Sub Sort_pr_range() ActiveSheet.Unprotect 'Unprotect the sheet Range("A1:F100").Sort Key1:=Range("B1"), _ 'where "B1" will be the sort pri Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom ActiveSheet.Protect 'Protect the sheet End Sub If this does not work for you then please come back to us and we will assist you. -- Thank you and Regards Garreth Lombard "Stuart Hodge" wrote: I'm trying to create a table where users can't edit the content of the cells but can edit the ordering of the table- what's the best way to achieve this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allowing users to use filters and sort on protected pivot table | Excel Discussion (Misc queries) | |||
Allowing users to use filters and sort on protected pivot table | Excel Discussion (Misc queries) | |||
Protected worksheet allow users | Excel Discussion (Misc queries) | |||
Can't uncheck boxes in Pivot Table dropdowns | Excel Discussion (Misc queries) | |||
make Pivot table show only available values in dropdowns | Excel Discussion (Misc queries) |