View Full Version : Solved: test for Add-Ins, prompt to activate if not
mperrah
04-20-2007, 07:44 PM
Hello again all,
I have a form that requires an add-in.
Can I prompt the user to activate an add-in if it is not present on load?
Or just activate with a macro without a prompt?
Thanks in advance
mdmackillop
04-20-2007, 10:09 PM
You can add/remove it on opening/closing
Private Sub Workbook_Open()
AddIns("vbax KB Search").Installed = True
End Sub
mperrah
04-21-2007, 12:10 AM
Do I just type analysis toolpak in the parenthases? (sp?)
Private Sub Workbook_Open()
AddIns("analysis toolpak").Installed = True
End Sub
Mark
mperrah
04-21-2007, 12:34 AM
That was it.
I needed analysis toolpak - vba for the weeknum() formula.
Thank you, yet again.
Mark
:thumb
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.