Sort Protect Sheet
 

Is it possible to sort data once the sheet has been protected? I check
the Sort option in the "Allow all users of this worksheet to" dialog
box, but am not able to sort. Thanks
Norma


--
nvermilye
------------------------------------------------------------------------
nvermilye's Profile: http://www.excelforum.com/member.php...o&userid=31328
View this thread: http://www.excelforum.com/showthread...hreadid=510112

Sort Protect Sheet
 

All the cells in the range that needs to be sorted needs to be unlocked, too.

nvermilye wrote:

Is it possible to sort data once the sheet has been protected? I check
the Sort option in the "Allow all users of this worksheet to" dialog
box, but am not able to sort. Thanks
Norma

--
nvermilye
------------------------------------------------------------------------
nvermilye's Profile: http://www.excelforum.com/member.php...o&userid=31328
View this thread: http://www.excelforum.com/showthread...hreadid=510112

--

Dave Peterson