View Single Post
  #5  
Old April 29th, 2010, 04:42 PM posted to microsoft.public.excel.newusers
Blue Max
external usenet poster
 
Posts: 301
Default Sorting tables on protected worksheets

Thank you, Dave, some interesting features. I appreciate your reply and
will take a look at this option.

Thanks,

Richard

*****************
"ozgrid.com" wrote in message
...
Record a macro for your sort, then see this page;
http://www.ozgrid.com/VBA/excel-macr...cted-sheet.htm

The UserInterfaceOnly is my preference in case the Macro bugs out leaving
your Worksheet unprotected.




--
Regards
Dave Hawley
www.ozgrid.com
"Blue Max" wrote in message
...
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?