sorting a protected sheet

R

RmB

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I can not sort or filter data on a protected sheet. What am I missing? Have looked all through the help file and see no solutions.
Thank you, RmB
 
C

CyberTaz

Hi RmB -

Can you be a little more explicit about what you are attempting to do step
by step & what you're expecting v. what is happening? The whole concept of
protecting a sheet is to prevent it & its content from being altered, so I'm
not clear on exactly what the problem is.
 
S

Shane Devenshire

Hi,

You aren't missing anything. Although the PC version of Excel allows you to
control access to sorting, and many other options the Mac version does not.
So when the sheet is protected you can't sort.

It might be possible to do something with Apple Script but I can't help with
that.
 
Top