Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is the situation.
I have a "personal.xls" that loads a custom toolbar and contains one of many frequently used macros. I have another workbook with 6 frequently used macros that is accessible publicly, department wide; we will call this workbook "Stuff.xls". I would like to call the macro "GL_Import" from the toolbar that "Personal.xls" loaded. I know that I can link the buttons directly to the macros in the "Stuff.xls" workbook. I could also copy the modules, forms, and such from the"Stuff.xls" to "personal.xls" and have them linked directly to the copy in my "personal.xls". What I want to do is link the custom toolbar button to a macro in "personal.xls" which opens "stuff.xls" then runs the "GL_Import". The answer is probably not nearly as difficult as I have made it. Thanks for you help in advance. Mic |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CALLING MACROS FROM A NEW WORKSHEET | Excel Discussion (Misc queries) | |||
calling a module | Excel Discussion (Misc queries) | |||
How to add formula calling up current workbook when sheet copied | Excel Discussion (Misc queries) | |||
Calling macros from another XL Workbook | Excel Programming | |||
Close current Workbook after calling macro in other | Excel Programming |