hide excel macros

[lamlancer]

i understand how to password protect a macro's code but is there a way to hide the names of the macros as well so that when the user selects 'alt f8' the names are not listed

thanks for any help or suggestions

 

[rmikesmith]

At the top of the module containing your macros add the following line:

Option Private Module

Regards,
Mike

 

[lamlancer]

daaaaaaaa

that was simple

thanks very much

only problem is that now my ctrl keys assigned to the macros do not work

any suggestions

thanks once again

 

[rmikesmith]

The only way I know around this is to convert your workbook into an Add-In. First, remove the Option Private Module statement. Then, click on ThisWorkbook in the Project Explorer window of the VBE and set its IsAddin property to True.


Regards,
Mike