When something in module is shown as a macro

[zigzagdna]

Subject: Excel - When something in module is shown as a macro
I am on Excel 2007. I inherited a complex spreadsheet from someone and trying to understand it.
When I go in Visual Basic Editor, I see several modules, one module is optimization4. It has several private functions and subroutines and two public subroutines:
Optimize4 and removemarkers.

When I go in view macros in Excel file, I see two macros shown:
Optimize4
Optimization4! Removemarkers

Question, first macro is not shown as Optimization4!Optimize4, why?
I see in visual basic editor that there are other modules which also have removemarkers subroutine, maybe that’s why it is preceded by Optimization4! While there is only one Optimze4.
Is my understanding correct? Appreciate your insight.

Thanks a lot.





I

 

[isabelle]

hi,

you should know that there "Module" and "Class Module"
"Class module" being sheets in the workbook, a workbooks or a class module

if the subroutine is placed in a class module
you will see:

MyClassModule.Macro1
or
Sheet1.Macro1
or
ThisWorkbook.Macro1

if the subroutine is placed in a module
you will see:

Macro1

if the same name for a subroutine appears in two different modules.
you will see:

Module1.Macro1
Module2.Macro1

--
isabelle



Le 2012-09-20 22:23, (e-mail address removed) a écrit :

Subject: Excel - When something in module is shown as a macro
I am on Excel 2007. I inherited a complex spreadsheet from someone and trying to understand it.
When I go in Visual Basic Editor, I see several modules, one module is optimization4.

It has several private functions and subroutines and two public subroutines:

Optimize4 and removemarkers.

When I go in view macros in Excel file, I see two macros shown:
Optimize4
Optimization4! Removemarkers

Question, first macro is not shown as Optimization4!Optimize4, why?
I see in visual basic editor that there are other modules which also have removemarkers subroutine,

maybe that’s why it is preceded by Optimization4! While there is only one Optimze4.

 

[zigzagdna]

Subject: Excel - When something in module is shown as a macro I am on Excel 2007. I inherited a complex spreadsheet from someone and trying to understand it. When I go in Visual Basic Editor, I see several modules, one module is optimization4. It has several private functions and subroutines and two public subroutines: Optimize4 and removemarkers. When I go in view macros in Excel file, I see two macros shown: Optimize4 Optimization4! Removemarkers Question, first macro is not shown as Optimization4!Optimize4, why? I see in visual basic editor that there are other modules which also have removemarkers subroutine, maybe that’s why it is preceded by Optimization4! While there is only one Optimze4. Is my understanding correct? Appreciate your insight. Thanks a lot. I

Isabelle:
Excellent description. Thanks a lot.

Prem

 

[isabelle]

you're welcome! ..feedback is always appreciated!

note that if you write a Private Sub(), this one is not shown in view macros in Excel file

also i suggest you as read the following subjects: Function(), Sub(), Private Sub(), Public Sub()
http://www.excelfunctions.net/VBA-Functions-And-Subroutines.html