Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro button
Hi
I have a custom tool bar button assigned to a macro to format a remittance advice. The macro runs through 5 other macros in order ending up with it saving the remittance to another sheet. If i run the macros separately they run fine. If i run the macro that loads the other macros from the macro screen it works fine but when i run it from the custom toolbar button it opens up another sheet as well as running my other macros!!! Does any one have any idea why this may be happening. Thanks ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro button
sounds like it might have to do with some unqualifed references. When run
from the button they may not refer to what you would think. This would be particularly true if the code is in a worksheet module. Unless the code is related to events in the worksheet, it should be in a general module. -- Regards, Tom Ogilvy "Ed" wrote in message ... Hi I have a custom tool bar button assigned to a macro to format a remittance advice. The macro runs through 5 other macros in order ending up with it saving the remittance to another sheet. If i run the macros separately they run fine. If i run the macro that loads the other macros from the macro screen it works fine but when i run it from the custom toolbar button it opens up another sheet as well as running my other macros!!! Does any one have any idea why this may be happening. Thanks ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
Using Macro to sort without clicking on macro button | Excel Discussion (Misc queries) | |||
use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
F9 Button Macro | Excel Discussion (Misc queries) | |||
Macro Button | Excel Discussion (Misc queries) |