Dave Peterson Wrote: [color=blue]
You haven't avoided the problem. You've just passed the problem to the
recipient. Most users of excel wouldn't know what to do with the text
of a
macro (in my experience).

mr_ben wrote:

or why don't you do it the way I said originally and avoid all the
above
problems

--


not how I see it

all you need to do is import the file (module), you don't need to
"touch" the text of the macro itself. (unless I'm completely missing
the point)

I may admittedly not explained the process that well... :oops:


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=569050