ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   IRM and Sorting (https://www.excelbanter.com/excel-programming/401397-irm-sorting.html)

James Brouahrd

IRM and Sorting
 
Is it possible to restrict change access to an Excel document and still give
the ability to sort?

Thanks!
James

Basilisk96

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

James Brouahrd

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


Basilisk96

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



All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com