If I did Insert =Module, then in that module I place code like

Sub Dothings()
msgbox "In Dothings"
End Sub

then as long as the workbook containing that macro is open, it would
available like your recorded macros.

If you are declaring your sub as private or putting in arguments or using
sheet modules or the thisworkbook module, then your code would probably not
be available.

--
Regards,
Tom Ogilvy

"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=491889