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
  • Did you ever find a solution for this? Experiencing the same issues but can't seem to get around it.

    Thursday, April 02, 2015 2:24 PM
  • The only solution was to convince IT to remove RMS.
    Thursday, April 02, 2015 11:39 PM
  • I suppose you haven't found any further info. Having exactly the same problem
    Thursday, May 07, 2015 5:03 PM