All users path
Ok. Then, when you add your add-in with AddIns.Add(nom). The registration
is
only possible at an All-users level?
If yes, then is there a way to get an All users path for the xlsStart and
Model?
Thanks,
Thierry Paradis.
----------------------------
I'm not clear about what you wanted to do...
The Addin.Add method works only for the current Excel user. Specifically,
the add-in will appear under this registry key to indicate it's available
but not selected in the Tools, Add-ins dialog for the current user:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Add-in Manager
(Adjusting the "11.0" for your version of Excel.)
If you want to have the add-in appear in Tools, Add-ins for all users, I
don't know how to do that. A workaround is to copy it to the
Application.Path & "\xlstart" folder. It will not appear in Tools, Add-ins
but Excel will open it for all users and if you have startup code to modify
menus it will run.
--
Jim
|