View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Philip Mariconda Philip Mariconda is offline
external usenet poster
 
Posts: 4
Default Run a macro problem?

Actually, when you declare a valid Sub, it becomes PART of
the language for all intents and purposes. You would run
it just like you were running any other method (i.e.
CheckSpelling.) You may need to qualify the Sub with the
module it is contained in (i.e. MyModule.MySub).

Hope that helps,
Phil

-----Original Message-----
I have a lengthy code stored in a module and assigned to

a
button. However, I also want that module to run from an
additional button. How can I run this module without
having to copy and paste all that lenghty code into two
places. Is there like a module.execute command?

SDC