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.

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.