Hi, I am developing a custom Excel application. I have applied AD RMS to my Excel app.
My question is: without giving full RMS permissions, is there a way to allow an RMS-protected to run VBA code that changes a cell or worksheet's protections?
The application works with data with dynamic dimensions, so I'd like to be able to adjust the cells that are protected, then apply worksheet protections. Currently, after RMS is applied, the VBA throws an error when locking/unlocking a cell or protecting/unprotecting a worksheet.
Thanks for the quick response.
My RMS-protected Excel spreadsheet can run macros and most VBA code, but throws an error only when there is specific code that changes the protection of cells or worksheets.
I'm hoping for a solution that doesn't involve changing RMS itself...it looks to be a big headache.