0

I want to be able to have other users of an excel file look at, but not modify the code used in an excel sheet (for transparency and security reasons).

I realize similar questions have been asked on SO before, but those deal with hiding the source code, which I want to avoid.

Is there any way I can basically put a macro on read-only?

Mikku
  • 6,538
  • 3
  • 15
  • 38
9 Guy
  • 176
  • 3
  • 14
  • 1
    Possible duplicate of [Lock down Microsoft Excel macro](https://stackoverflow.com/questions/6760981/lock-down-microsoft-excel-macro) – Danny Papadopulos Aug 24 '19 at 17:12
  • @DannyPapadopulos I addressed this in the second sentence. I want the source to remain visible, i.e read only – 9 Guy Aug 24 '19 at 17:14
  • I don't think that's possible. You could lock the macros completely and have a macro inside that would save all modules as text files for example once the Workbook is opened. Or something of that sort. – Danny Papadopulos Aug 24 '19 at 17:41
  • You can't. If you lock the modules with a password then a hex editor can be used to bypass that. If the user can open the workbook then there's nothing you can do except make it more difficult. – Michael Z. Aug 24 '19 at 19:51
  • Locking the modules sounds like enough for your situation – Michael Z. Aug 24 '19 at 19:52

0 Answers0