Avoid calling the file where the code si saved

[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.

The button(that i already created) 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 wanted to do the same thing with my macro.

Any ideas ?

[xladept]

I always have my code book open, it needn't be the active book.

[mehmetcik]

Have you ever made use of your personal workbook?

Select developer, macros, start recorder, select "In Personal Workbook", enter a letter like g that will run the macro.

record a small macro, stop the recorder.

Now whatever sheet you are in. pressing ctrl and g will run that macro

[Verbamore]

Have you ever made use of your personal workbook?

Select developer, macros, start recorder, select "In Personal Workbook", enter a letter like g that will run the macro.

record a small macro, stop the recorder.

Now whatever sheet you are in. pressing ctrl and g will run that macro

Thank you mehmetcik but my idea was to use one button on Ribbon. Do you have any idea for that?

[jhuang5132]

To have one button on the ribbon that works on all workbooks, you should place it in the Personal Workbook. Do not put any data inside the personal workbook, and just store your macros there. Hide the personal workbook so that the macros will always be readily available but will not show up and disrupt you.

[Verbamore]

To have one button on the ribbon that works on all workbooks, you should place it in the Personal Workbook. Do not put any data inside the personal workbook, and just store your macros there. Hide the personal workbook so that the macros will always be readily available but will not show up and disrupt you.

I am trying but i said "cannot edit a macro on a hidden workbook.Unhide the workbook using the unhide command"
I don't know why it shows me this, I just click the excel icon

[Verbamore]

To have one button on the ribbon that works on all workbooks, you should place it in the Personal Workbook. Do not put any data inside the personal workbook, and just store your macros there. Hide the personal workbook so that the macros will always be readily available but will not show up and disrupt you.

I am trying but it said "cannot edit a macro on a hidden workbook.Unhide the workbook using the unhide command"
I don't know why it shows me this, I just click the excel icon

[jhuang5132]

To edit the macro, you need to unhide it.

I do believe that another way is to insert a new module, paste the code you have, and then exit out of the personal workbook, while saving all changes. Then you can hide the workbook. After that, when you want to edit your macro, go to Macros, select your macro, and Step-Into it. After you edit, press the save icon at the top.

The hidden personal workbook should still be able to run as it is hidden in the background.

[Verbamore]

To edit the macro, you need to unhide it.

I do believe that another way is to insert a new module, paste the code you have, and then exit out of the personal workbook, while saving all changes. Then you can hide the workbook. After that, when you want to edit your macro, go to Macros, select your macro, and Step-Into it. After you edit, press the save icon at the top.

The hidden personal workbook should still be able to run as it is hidden in the background.

Thanks for your help jhuang5132