add in

R

raj

Dear all,

I don't have any specific query. But I am looking for a
way to create a customized and user-specific addin in
excel. The user must have the option to activate and
deactivate the addin. Can anyone let me know the way how
to do that

Regards
Raj
 
B

Bob Phillips

Raj,

Just develop a workbook as you would usually do it, and then save the file
as an add-in (type xla). The user installs the add-in, and that gives them
the option to activate and de-activate via Tools>Add-Ins

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
T

Tom Ogilvy

In the vbe, look at the properties of the ThisWorkbook entry in the project
explorer. One of the properties is IsAddin.
 
Top