protect public sub

[johnny]

Hi,
Please any suggestions.

In a workbook, I created many public subs, I protected it from
viewing.
But when I open another workbook at the same time, I still can go the
Macro menu, and see all these functions, and can run them through the
pop up macro window.

How do I hide all these public procedures from running and viewing ?
I need to them in the public module, so other sheets can use them.

Thanks for your advice.

 

[Jim Thomlinson]

At the top of the module add the following line of code...

Option Private Module

 

[johnny]

At the top of the module add the following line of code...

Option Private Module

Thanks a lot