Lock macros in Excel

[jenwalton]

Is it possible to lock macros in Excel - I have one saved in a workbook and want to apply a password (not to the whole file, just the macro) in order for another user to view or especially, edit, the macro.

Any help or advice you could give would be much appreciated.

Thanks!!

 

[RobBroekhuis]

In the VB editor, right-click on your project in the project explorer window, and choose "VBA Project Properties". On the "Protection" tab, you can set a password for viewing (and therefore, editing) the VBA code.
Rob