If your macros are fired from custom menus or custom toolbar then you
should destroy them at shutdown so they don't persist in the TLB. This
way, all you need to do is transfer your Personal.xls file.
Any custom menus/toolbars you create at startup will not persist when
another user runs Excel (
AFAIK)! Better yet is to put your macros in an
addin if they need to be used by others.
I assume you know custom menus/toolbars appear on the Addins tab in
XL12 and later!<g
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion