Imported Visual Basic Module - Save Macros for use in Excel

  • Follow


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.
0
Reply Utf 12/2/2009 9:02:02 PM

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

On Wed, 2 Dec 2009 13:02:02 -0800, Pat Adams
<PatAdams@discussions.microsoft.com> 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.

0
Reply Gord 12/2/2009 9:44:30 PM


1 Replies
248 Views

(page loaded in 0.046 seconds)

Similiar Articles:
















7/18/2012 8:49:47 AM


Reply: