Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
microsoft visual basic-compile error in hidden module:modMain Roman Piotr Excel Discussion (Misc queries) 3 January 23rd 13 01:49 PM
Visual Basic Macros Mia Skier Excel Discussion (Misc queries) 3 June 8th 08 04:12 AM
Visual Basic module from Excel 2003 crashing in Excel 2007 Chuck Angier Excel Discussion (Misc queries) 0 December 4th 07 01:42 AM
Visual Basic Macros, relative position [email protected] Charts and Charting in Excel 3 November 14th 06 11:33 PM
exel : visual basic: compile error in hidden module : Distmon cde01 Excel Discussion (Misc queries) 1 July 26th 05 01:15 PM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"