IRM and Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks!
James
 
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top