How to dynamically add a reference to personal.xls ?

[John Mitchell]

I use personal.xls to perform customisation whenever I open a new
workbook. For example, I add menu items to the toolbar, which is very
useful. However, if I want personal.xls subs and functions to be
callable by VB code in the new workbook I first have to use the VBE
Tools menu to manually add a reference to personal.xls. Is it possible
to add an external reference to personal.xls programatically? I'm sure
there must be a way of doing this. Guidance appreciated...

Regards, John M

 

[ste]

Hi,
on open:
ThisWorkbook.VBProject.References.AddFromFile......

regards,
ste

 

[John Mitchell]

Thanks. Just what I was looking for. Much obliged.

Cheers, John M