Good catch on Bob's part - Spaces in a workbook name require the name be
enclosed in single quotes.

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote:

the macro should be in a general module and not in a sheet module or the
thisworkbook module. the macro should be public, but this is the default.

--
Regards,
Tom Ogilvy


"ppyxl" wrote:


Hi, thanks!

error msg still! macro not found

is it any speical setting for the macro in another excel work book


--
ppyxl
------------------------------------------------------------------------
ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116
View this thread: http://www.excelforum.com/showthread...hreadid=560641