| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is it possible to sort a protected worksheet?
I have a worksheet that I've protected all the cells that
contain formulas so that other user's can't inadvertently delete them. However, I need to be able to sort the data, but it's not an option when the sheets protected. Any suggestions? |
|
#2
|
|||
|
|||
|
turn on macro recorder
unprotect sort protect -- Don Guillett SalesAid Software "Phyllis" wrote in message ... I have a worksheet that I've protected all the cells that contain formulas so that other user's can't inadvertently delete them. However, I need to be able to sort the data, but it's not an option when the sheets protected. Any suggestions? |
|
#3
|
|||
|
|||
|
Hi
only possible using VBA (first unprotecting the sheet, then sorting and protecting the sheet again) -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... I have a worksheet that I've protected all the cells that contain formulas so that other user's can't inadvertently delete them. However, I need to be able to sort the data, but it's not an option when the sheets protected. Any suggestions? |
|
#4
|
|||
|
|||
|
Thanks. I tried that and I get a message that the project
is locked, and it won't record the macro. -----Original Message----- Hi only possible using VBA (first unprotecting the sheet, then sorting and protecting the sheet again) -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... I have a worksheet that I've protected all the cells that contain formulas so that other user's can't inadvertently delete them. However, I need to be able to sort the data, but it's not an option when the sheets protected. Any suggestions? . |
|
#5
|
|||
|
|||
|
Hi
o.k. then you first have to unprotect your workbook -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... Thanks. I tried that and I get a message that the project is locked, and it won't record the macro. -----Original Message----- Hi only possible using VBA (first unprotecting the sheet, then sorting and protecting the sheet again) -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... I have a worksheet that I've protected all the cells that contain formulas so that other user's can't inadvertently delete them. However, I need to be able to sort the data, but it's not an option when the sheets protected. Any suggestions? . |
|
#6
|
|||
|
|||
|
Unprotect the project in the VBE--not unprotect the workbook in excel.
(In the OP's other thread, the thought of a Shared workbook was discussed, too.) Frank Kabel wrote: Hi o.k. then you first have to unprotect your workbook -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... Thanks. I tried that and I get a message that the project is locked, and it won't record the macro. -----Original Message----- Hi only possible using VBA (first unprotecting the sheet, then sorting and protecting the sheet again) -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... I have a worksheet that I've protected all the cells that contain formulas so that other user's can't inadvertently delete them. However, I need to be able to sort the data, but it's not an option when the sheets protected. Any suggestions? . -- Dave Peterson |
|
#7
|
|||
|
|||
|
I have a worksheet that I've protected ...
Don't know if this would apply, but in the latest versions of Excel, when you go Tools | Protection | Protect Sheet you can select "Allow all users of this worksheet to:" and select "Sort", which is nearer the bottom of the list. -- Dana DeLouis Win XP & Office 2003 "Dave Peterson" wrote in message ... Unprotect the project in the VBE--not unprotect the workbook in excel. (In the OP's other thread, the thought of a Shared workbook was discussed, too.) Frank Kabel wrote: Hi o.k. then you first have to unprotect your workbook -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... Thanks. I tried that and I get a message that the project is locked, and it won't record the macro. -----Original Message----- Hi only possible using VBA (first unprotecting the sheet, then sorting and protecting the sheet again) -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... I have a worksheet that I've protected all the cells that contain formulas so that other user's can't inadvertently delete them. However, I need to be able to sort the data, but it's not an option when the sheets protected. Any suggestions? . -- Dave Peterson |
|
#8
|
|||
|
|||
|
does selecting 'sort' work?
in the protect menu i have ticked 'autofilter' and i can use autofilter, and i have ticked 'sort', but i can't use sort - is this a bug, or am i missing something? (using excel 2002) "Dana DeLouis" wrote: I have a worksheet that I've protected ... Don't know if this would apply, but in the latest versions of Excel, when you go Tools | Protection | Protect Sheet you can select "Allow all users of this worksheet to:" and select "Sort", which is nearer the bottom of the list. -- Dana DeLouis Win XP & Office 2003 "Dave Peterson" wrote in message ... Unprotect the project in the VBE--not unprotect the workbook in excel. (In the OP's other thread, the thought of a Shared workbook was discussed, too.) Frank Kabel wrote: Hi o.k. then you first have to unprotect your workbook -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... Thanks. I tried that and I get a message that the project is locked, and it won't record the macro. -----Original Message----- Hi only possible using VBA (first unprotecting the sheet, then sorting and protecting the sheet again) -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... I have a worksheet that I've protected all the cells that contain formulas so that other user's can't inadvertently delete them. However, I need to be able to sort the data, but it's not an option when the sheets protected. Any suggestions? . -- Dave Peterson |
|
#9
|
|||
|
|||
|
i think i know what i was missing - you can't sort (but can filter) locked
cells "mnbv" wrote: does selecting 'sort' work? in the protect menu i have ticked 'autofilter' and i can use autofilter, and i have ticked 'sort', but i can't use sort - is this a bug, or am i missing something? (using excel 2002) "Dana DeLouis" wrote: I have a worksheet that I've protected ... Don't know if this would apply, but in the latest versions of Excel, when you go Tools | Protection | Protect Sheet you can select "Allow all users of this worksheet to:" and select "Sort", which is nearer the bottom of the list. -- Dana DeLouis Win XP & Office 2003 "Dave Peterson" wrote in message ... Unprotect the project in the VBE--not unprotect the workbook in excel. (In the OP's other thread, the thought of a Shared workbook was discussed, too.) Frank Kabel wrote: Hi o.k. then you first have to unprotect your workbook -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... Thanks. I tried that and I get a message that the project is locked, and it won't record the macro. -----Original Message----- Hi only possible using VBA (first unprotecting the sheet, then sorting and protecting the sheet again) -- Regards Frank Kabel Frankfurt, Germany "Phyllis" schrieb im Newsbeitrag ... I have a worksheet that I've protected all the cells that contain formulas so that other user's can't inadvertently delete them. However, I need to be able to sort the data, but it's not an option when the sheets protected. Any suggestions? . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting protected worksheet | Excel Discussion (Misc queries) | |||
| How can I activate cell shading in a protected worksheet? | Excel Discussion (Misc queries) | |||
| Sorting protected worksheets | Excel Discussion (Misc queries) | |||
| Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
Linear Mode
