#1   Report Post  
Posted to microsoft.public.excel.programming
raj raj is offline
external usenet poster
 
Posts: 1
Default add in

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default add in

Set Workbook IsAddin Property to true.

--
Olly


"raj" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default add in

and how do we do that.

Regards
-----Original Message-----
Set Workbook IsAddin Property to true.

--
Olly


"raj" wrote in message
...
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



.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default add in

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

--
Regards,
Tom Ogilvy

wrote in message
...
and how do we do that.

Regards
-----Original Message-----
Set Workbook IsAddin Property to true.

--
Olly


"raj" wrote in message
...
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



.



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default add in

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 ToolsAdd-Ins

--

HTH

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

"raj" wrote in message
...
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"