Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MACRO Problem | Excel Discussion (Misc queries) | |||
VB Macro Problem | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
macro problem | Excel Discussion (Misc queries) |