Imported Visual Basic Module - Save Macros for use in Excel

[Pat Adams]

I've imported a module into visual basic editor and have saved it, but can't
seem to pull up the macros in excel. thanks.

 

[Gord Dibben]

You mean they don't show up in a list of Macros?

Maybe it is a Class Module or all macros within the module are Private

Private Sub hello_macro()
MsgBox "hello"
End Sub

Will not be listed in Tools>Macro>Macros

You can access by typing the macroname and "Run"


Gord Dibben MS Excel MVP