View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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?