The process requires you to save the macro as a BAS file then read the
BAS file into the 2nd workbook. Chip Pearson has good instructions at
his website
'Programming In The VBA Editor'
(
http://www.cpearson.com/excel/vbe.aspx)
Read the two bullets at the top of the webpage carefully especially
•Next, you need to enable programmatic access to the VBA Project. In
Excel 2003 and earlier, go the Tools menu (in Excel, not in the VBA
editor), choose Macros and then the Security item. In that dialog, click
on the Trusted Publishers tab and check the Trust access to the Visual
Basic Project setting.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=175509
Microsoft Office Help