Take the 2-minute tour ×  I have a master workbook containing a
macro which opens another workbook containing a demand forecast.
The workbook opened through the macro is downloaded from a
customer portal and is all new every day without possibility of
editing it beforehand.  The macro then loops through the
information and creates new readable and more intuitive
worksheets. However, on a few of these worksheets I would like
to add some event-driven code to give tooltips when mousing over
or selecting cells.  Is there any possibility (without
installing add-ons from vanilla Excel 2010) to add code to
worksheet objects created during a macro?  The layout of the
processed workbook is more or less static, so I was wondering if
I should create a template file and then copy the input into it.
That would allow me to have coded the events before data is
added. Is this the best possibility?  share|improve this
question Looks like you can do this:
Application.VBE.ActiveVBProject.VBComponents.Import
("c:\MyFolder\MyFile