Adding code to workbooks/worksheets using VBA

[Tony Bell]

Is it possible to use VBA to write code to workbooks or
worksheets. For example, how could I write a BeforeClose
event handler to ThisWorkbook. There are a number of
workbooks that link to code I've written and I would like
to be able to automatically add code to these workbooks
when they access my code.
Can anyone help?

 

[Bob Phillips]

Hi Tony,

Chip Pearson's site http://www.cpearson.com/excel/vbe.htm shows some
techniques in this area

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Look at Chip Pearson's site for information on this

http://www.cpearson.com/excel/vbe.htm

 

[onedaywhen]

You may be better off writing a generic component (e.g. a VB6 COM
add-in or VSTO .NET project) which hooks these events rather than
embedding code in individual workbooks.