Thread: Macro button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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