protect public sub
 

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.

protect public sub
 

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.

protect public sub
 

On Apr 23, 1:53 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
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.

Thanks a lot