|
can some body help me
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 |
can some body help me
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 |
can some body help me
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. --- Regards, Norman "ditzafar" wrote in message ... 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 |
can some body help me
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 |
can some body help me
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 |
can some body help me
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. -- Regards, Tom Ogilvy "Jim Thomlinson" wrote in message ... 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 |
| All times are GMT +1. The time now is 07:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com