How to dynamically add a reference to personal.xls ?
 

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

How to dynamically add a reference to personal.xls ?
 

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

regards,
ste

How to dynamically add a reference to personal.xls ?
 

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

Cheers, John M

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

regards,
ste