can some body help me

[ditzafar]

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

 

[Guest]

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

 

[Norman Jones]

Hi Ditzafar,

To make the macros available to any open workbook, store them in your
Personal.xls file.

I suspect that when you record macros, you select the option to store the
macro in your Personal macro book.

 

[Tom Ogilvy]

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

 

[Guest]

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.

 

[Tom Ogilvy]

If the personal workbook is closed, then no it isn't. Granted, the personal
workbook is opened when excel is opened. I could achieve essentially the
same behavior with any workbook if I hide it, saved it, then placed it in
the xlstart directory. Also, there are other causes that make a macro "not
available" (even if in the personal workbook). However, perhaps your answer
is what the user is looking for, so no sense belaboring the point.