Imported Visual Basic Module - Save Macros for use in Excel

P

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enabling Visual Basic in Excel 2007 1
When something in module is shown as a macro 3
Excel version in Office Home & Student full featured?? 1
visual basic code in 2003 vs 2007 1
Visual Basic Function works fine in Excell 2003 but not in Excel 2 8
Copying macros to another workbook 2
VB prompts for Password when 'View Code' selected, r-click on tab 7
Assigning Macros in Excel 2007 1

Top