Automatically Loading Add-ins

Wednesday, 10 November 2010 by nkoknki | 0 comments

--Michael asked if there is a way to selectively load add-ins for specific worksheets. There is a way to do this, but it involves the use of macros attached to the Workbook module for the specific worksheets. Follow these general steps:

Load the worksheet for which you want a specific add-in loaded.
Press Alt+F11 to display the VBA Editor.
Double-click on the This Workbook object in the Project Explorer. Excel opens a code window for This Workbook.
Place the following macros in the code window:

     Private Sub Workbook_BeforeClose(Cancel As Boolean)
     AddIns("Add-In Name").Installed = False
     End Sub
     Private Sub Workbook_Open()
     AddIns("Add-In Name").Installed = True
     End Sub
In the code, change the name of the add-ins (Add-In Name) to the real name of the add-in you want to use with the worksheet.
Close the VBA Editor.
Save your worksheet.

--If you are not sure of the correct name for a particular add-in (see step 5), you can use the macro recorder to record the process of activating an add-in. That will show you the exact name you should use in the above macros.

Others tips

Source: Exceltips

Excel tips

Connecting IT

Automatically Loading Add-ins

0 comments:

Post a Comment

Learning English

Followers

Visitors