Where are you putting the code? Try inserting a module and then typing the
code (or copying/moving it) there. Then you should be able to bring it up
using Alt-F8.

"ditzafar" wrote:


When I recording the macro I can use it in others workbooks, but when
I'm typing the code in v.b I can use the macro only on the specific
workbook. I have no idea what can be the problem. thanks.


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