Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help.
Hi,
I have devloped a macro to automate a report. in this macro I have many module. When we click alt + F8 to run the macro , I see all the list of module.I just want ot show only main module. is there any way to hide other module except main module. PLease help with code. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help.
Make them Private:
Sub main() Call littleone Call bigone End Sub Private Sub littleone() MsgBox ("little") End Sub Private Sub bigone() MsgBox ("big") End Sub -- Gary''s Student - gsnu200781 "Smart Akhtar" wrote: Hi, I have devloped a macro to automate a report. in this macro I have many module. When we click alt + F8 to run the macro , I see all the list of module.I just want ot show only main module. is there any way to hide other module except main module. PLease help with code. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|