I don't really follow you... If you put it in your personal workbook then it
is always available for any workbook regardless whether this workbook is open
or not. At least that is what I thought I said. If you interpreted it in some
other way then my apologies.
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

Even if I chose thisworkbook, as long as thisworkbook is open, the macro is
equally available. Is it different for you?

--
Regards,
Tom Ogilvy

"Jim Thomlinson" wrote in message
...
When you record the macro you have the option to store it in This Workbook
or
in your Personal workbook. If you put it in your personal workbook then it
will be available to any workbook. You other option is to creat an addin
which is a little more complicated but it is easy to distribute to
others...
--
HTH...

Jim Thomlinson


"ditzafar" wrote:


When I'm recording macro in excel the macro is available to other
workbook, but when I'm typing the code in v.b. the macro is available
only to the specific workbook it wroten in. I have no idea why dose
it's happend


--
ditzafar
------------------------------------------------------------------------
ditzafar's Profile:
http://www.excelforum.com/member.php...o&userid=29475
View this thread:
http://www.excelforum.com/showthread...hreadid=491896