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. |
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. |
All times are GMT +1. The time now is 03:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com