Macro in excel Ribbon

[Verbamore]

Hi everybody,

I am using a button in ribbon to link the excel document with a macro code.
What i did was; i save the macro code in one excel document so when I click the button that i created on Ribbon, the file that I am using, call the file where the code is saved.

I Also changed this to don't show the excel security note:

File>Options>Trust Center>Trust Center Settings>Macro Settings>Enable all macros

but

when i click the button(that i already created), the macro is going to open the file where the vba code is saved.
Since the time is substantial, also the file is too big, to avoid freezing; I was wondering if there is any option to don't call the all file but just the code.
For example i want to do something like "copy" or Paste. when you click this buttons nothing need to be open besides the file that you are working. I want to do the same thing with my macro.

Any idea?

[Verbamore]

Any ideas about this above?

[Verbamore]

Does anybody have any ideas about this?