0

I have a series of macros that I want end users to be able to execute via a custom U/I that is ready and working. Is there a way that I can prevent users from having all features in the MS Project 'Macros' menu but still have them be able to use the custom U/I and macros as invoked from that U/I?

I have seen plenty of articles on how to disable macros, but I I simply want to block or hide he options in the 'Macros' but have VBA able to run via my custom U/I.

BigBen
  • 46,229
  • 7
  • 24
  • 40
James R. Eckert
  • 1
  • 1
  • There is always a way to see the code. VBA is not secure by any means. – braX Oct 02 '20 at 01:32
  • Just password protect it. If they have the skills to subvert that, then they have the skills to just write the VBA themselves. VBA isn't rocket science. You don't need extreme measures to protect it. – John Coleman Oct 02 '20 at 01:54
  • Protecting VBA code in Project is the same as in Excel; see [Best way to protect Excel VBA code?](https://stackoverflow.com/questions/16757119/best-way-to-protect-excel-vba-code). – Rachel Hettinger Oct 02 '20 at 15:59

0 Answers0