Greg

Info only..............

Macros do not reside in the Excel11.xlb file.

That file only saves the Menu and Toolbar customizations you have made.

Macros reside in workbooks, whether they be regular workbooks or add-ins.


Gord Dibben MS Excel MVP

On Thu, 8 Feb 2007 06:33:02 -0800, Greg wrote:

Is there a way to export and import specific macros instead of all macros?

This is the situation:
A co-worker and I share the same macros and up until a few months ago we
used to keep our macros updated by transfering the "Excel11.xlb" file located
at "C:\Documents and Settings\(user_profile)\Application
Data\Microsoft\Excel."
For a while now we have been making our own personal macros. Now if one of
us creates a macro and the other needs just that macro, how can we export and
import just that specific macro instead of transfering the entire file thus
overwriting any of the other persons personal macros?

Thanks in advance,
Greg