| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IRM and Sorting
Is it possible to restrict change access to an Excel document and still give
the ability to sort? Thanks! James |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IRM and Sorting
On Nov 19, 9:13 pm, James Brouahrd
wrote: Is it possible to restrict change access to an Excel document and still give the ability to sort? Thanks! James Restriction, sorting...via which mechanisms, VBA or user interaction? Please elaborate. -Basilisk96 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IRM and Sorting
Via user interaction. My thought is no, we'd have to use some custom coding,
but wanted to make sure. I didn't see an option in IRM. Thanks! James "Basilisk96" wrote: On Nov 19, 9:13 pm, James Brouahrd wrote: Is it possible to restrict change access to an Excel document and still give the ability to sort? Thanks! James Restriction, sorting...via which mechanisms, VBA or user interaction? Please elaborate. -Basilisk96 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IRM and Sorting
As far as I know, you'd have to do this with custom code.
The approach here would be "unprotect-sort-protect", which you would wrap into a lightweight sub / function. I am not familiar with IRM at all, so I can't help you there. Cheers, -Basilisk96 On Nov 27, 10:30 am, James Brouahrd wrote: Via user interaction. My thought is no, we'd have to use some custom coding, but wanted to make sure. I didn't see an option in IRM. Thanks! James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
| Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
| Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming | |||
Hybrid Mode
