Thread: All users path
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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