Thread: need help.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.