RMS-protected Excel cannot run VBA code to protect/unprotect a cell or worksheet


  • 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.


    Wednesday, August 28, 2013 8:58 PM

All replies

  • Hi poiu1234,

    Do you try to use Policy Template with right Allow Macros?

    Thursday, August 29, 2013 2:23 AM
  • 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 looks to be a big headache.

    Thursday, August 29, 2013 4:41 PM