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

Option Private Module
--
HTH...

Jim Thomlinson


"johnny" wrote:

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.