Force all workbooks into a single instance of Excel always?

[ks100]

There might be a more efficient way to do this but this is becoming increasingly time consuming:

At the beginning of my work day I open a macro enabled workbook which contains all the macros I need for my day.

I then proceed to open the first workbook I want to work on. It is able to access the macros I need from the "ALL OPEN WORKBOOKS" field.

By the 4th or 5th workbook I open, it eventually somehow ends up in a seperate instance of Excel and is unable to see the macro enabled workbook's macros. I then have to close the macro workbook and drag its icon into the workbook I'm working with in order to get it to show up again.

Is there a way to make certain macros universally accessible on my computer without having to have the seperate "macro" workbook open?

If not, is there a way to force all workbooks opened in Excel to stay in the same instance?

It isn't as simple as dragging the workbooks into the macro workbook, or file opening from the macro workbook, because I access the workbooks from hyperlinks on a sharepoint page.

Any help would be appreciated, thanks.

[newdoverman]

Save all the macros to the Personal Macro Workbook. This will make the macros available to all open workbooks. Directions for doing this can be found in the help files if you search for "personal macro workbook".

[ks100]

Working thanks.

[newdoverman]

Thanks for the feedback.