How do I give permission for certain functions in excel in locked.
 

I have locked all of a worksheet, except for a data entry portion. During
the locking proceedure, excel appears to give options for allowing the user
permission to use certain functions while the worksheet is locked, such as
"sort". However, that is not being allowed. Any ideas?

Hi
you have to unlock all cells which should be sorted as well

--
Regards
Frank Kabel
Frankfurt, Germany

tradinoncoffee wrote:
I have locked all of a worksheet, except for a data entry portion.
During the locking proceedure, excel appears to give options for
allowing the user permission to use certain functions while the
worksheet is locked, such as "sort". However, that is not being
allowed. Any ideas?