View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default How to attach a code module to a group of workbooks?

No, but you code put the code in an add-in. Then you run the code in the
add-in like so

Application.Run "myaddin.xla"mymacro"

--
HTH

Bob Phillips

"keithb" wrote in message
...
Is there a way to use a common code module and attach it to more than one
workbook? If so, how do you make its procedures and funtions available to
the workbook and the worksheets in the workbooks where it is attached.

Thanks,

Keith