awagdarikar
Board Regular
- Joined
- Jun 20, 2008
- Messages
- 115
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have an Excel Workbook having a protected worksheet. I want to allow users to Sort the Worksheet and at the same time ensure that they are not able to edit (chnage) data excpet sorting which is allowed. I tried using the Tools>Protect Sheet by checking the checkbox for "Sort". I protected the sheet after that. <o></o>
<o></o>
After that I thought I would be able to sort the data However i get the error pop up saying The worksheet is Read only and protected, the user needs to unprotect it for making any changes to it. <o></o>
<o></o>
My worksheet data has 250 columns and 1500 rows. I want to keep an option open to sort it with reference to any one of it.<o></o>
<o></o>
Can someone help?<o></o>
<o></o>
awagdarikar<o></o>
<o></o>
I have an Excel Workbook having a protected worksheet. I want to allow users to Sort the Worksheet and at the same time ensure that they are not able to edit (chnage) data excpet sorting which is allowed. I tried using the Tools>Protect Sheet by checking the checkbox for "Sort". I protected the sheet after that. <o></o>
<o></o>
After that I thought I would be able to sort the data However i get the error pop up saying The worksheet is Read only and protected, the user needs to unprotect it for making any changes to it. <o></o>
<o></o>
My worksheet data has 250 columns and 1500 rows. I want to keep an option open to sort it with reference to any one of it.<o></o>
<o></o>
Can someone help?<o></o>
<o></o>
awagdarikar<o></o>