Imported Visual Basic Module - Save Macros for use in Excel
 

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.

Imported Visual Basic Module - Save Macros for use in Excel
 

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 ToolsMacroMacros

You can access by typing the macroname and "Run"


Gord Dibben MS Excel MVP

On Wed, 2 Dec 2009 13:02:02 -0800, Pat Adams
wrote:

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.