View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
johnny johnny is offline
external usenet poster
 
Posts: 15
Default 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.