Sorting tables on protected worksheets
How do we configure our worksheet so that we can turn protection ON, but
still enable the table filter buttons in order to sort columns in a table?
No matter what settings we select for protection, including the sort and
auto-filter options, we cannot sort tables on a protected sheet. What is
the secret to allowing table sorts on a protected sheet?
|