If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Auto Loading Add-in and Reference when open file

Thread starter dwhitey1124
Start date Nov 23, 2014
Tags

add-in auto reference vba xla

dwhitey1124

New Member

Nov 23, 2014

Hi everyone, I'm working on a file that requires an add-in to be installed and a reference be set. Right now I have to add the Treemap.xla as an Add-In then open the workbookand then open the VBA editor and under Tools->References, turn on CHARTMAKER. I would like to shares this file with friends/peers that are tech savy. Is there a way to automatically open the add-in and set the reference to CHARTMAKER whenever the file is opened? The location of the add-in will be "J:\Administration\Excel Team\x Misc\Add-ins\Treemap". Any help would be really appreciated. Thanks in advance.