Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
public variables | Excel Discussion (Misc queries) | |||
Public Password | Excel Discussion (Misc queries) | |||
Public variable | New Users to Excel | |||
Public Curiosity | Excel Discussion (Misc queries) | |||
Public Function | Excel Discussion (Misc queries) |