qwerty1234
New Member
- Joined
- Dec 9, 2014
- Messages
- 20
I have a protected workbook that I cannot allow other users to edit. However, there are several other people who require the information on the spreadsheet, which is why it is protected. Unfortunately, due to Excel failure's apparently, Excel will not allow the users to sort the different columns without unlocking those columns, which I cannot allow as it will give those users access to change the data.
I will be the first to admit that I'm not great with Macros. I tried to write a code that would allow a user to sort the sheet without unlocking the cells, but I don't know how to do it for all columns. Instead, I was thinking of using a combo box as a drop down to allow the users to sort the columns that way. The drop down would list the different column headers, and then the user can select which one they want, then ascending or descending, and a macro would do the sorting for them.
Is this an option? And is there someone who could help me with the coding? Or does someone have a code that would automatically unprotect the sheet, sort the column in question, and then reprotect the sheet without having to activate a macro (most of these user's no nothing about coding)? I know I'm not the first person to run into this issue.
This is the kind of data I'm looking at:
<colgroup><col width="108" span="7" style="width:81pt"> </colgroup><tbody>
</tbody>
So I can't have the users changing the part number, cost, due date, etc., but I want them to be able to sort by any of those columns.
Any help would be appreciated.
I will be the first to admit that I'm not great with Macros. I tried to write a code that would allow a user to sort the sheet without unlocking the cells, but I don't know how to do it for all columns. Instead, I was thinking of using a combo box as a drop down to allow the users to sort the columns that way. The drop down would list the different column headers, and then the user can select which one they want, then ascending or descending, and a macro would do the sorting for them.
Is this an option? And is there someone who could help me with the coding? Or does someone have a code that would automatically unprotect the sheet, sort the column in question, and then reprotect the sheet without having to activate a macro (most of these user's no nothing about coding)? I know I'm not the first person to run into this issue.
This is the kind of data I'm looking at:
| contract | part number | item name | quantity | cost | due date | supplier |
| a | 1 | soup | 2 | 2.5 | 3/15/2015 | Costco |
| b | 2 | beef | 1 | 3.4 | 3/18/2015 | Big Y |
| c | 3 | bread | 3 | 3.1 | 3/11/2015 | Big Y |
| d | 4 | water | 7 | 2 | 3/29/2015 | Price Chopper |
| e | 5 | milk | 4 | 3 | 4/1/2015 | Stop N Shop |
| b | 2 | beef | 1 | 3.4 | 4/18/2015 | Big Y |
| b | 2 | beef | 1 | 3.4 | 3/18/2015 | Big Y |
| d | 4 | water | 7 | 2 | 5/1/2015 | Price Chopper |
| a | 1 | soup | 2 | 2.5 | 4/10/2015 | Costco |
<colgroup><col width="108" span="7" style="width:81pt"> </colgroup><tbody>
</tbody>
So I can't have the users changing the part number, cost, due date, etc., but I want them to be able to sort by any of those columns.
Any help would be appreciated.
