[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Create Add-in

Fredrik E. Nilsen

12/17/2006 1:40:00 AM

I'm trying to create an add-in to distribute to several users. The
add-in is used to apply user-defined chart-settings to excisting
charts. I know how to create the code to apply the settings, to save
it as an add-in and to load from tools -> add-ins...

But: how can the user run the add-in?

--
Fredrik E. Nilsen
7 Answers

Bob Phillips

12/17/2006 2:04:00 AM

0

They should store it in a directory, and then in Excel goto Tools>Addins,
hit the browse button and find the addin file, and open it there. The addin
will open with Excel each time from then on.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Fredrik E. Nilsen" <fenilsen.nospam@chello.no> wrote in message
news:ap79o29r670fmfn2pplvdrds1h5mjjqnu1@4ax.com...
> I'm trying to create an add-in to distribute to several users. The
> add-in is used to apply user-defined chart-settings to excisting
> charts. I know how to create the code to apply the settings, to save
> it as an add-in and to load from tools -> add-ins...
>
> But: how can the user run the add-in?
>
> --
> Fredrik E. Nilsen


Fredrik E. Nilsen

12/17/2006 2:17:00 AM

0

On Sun, 17 Dec 2006 02:04:10 -0000, "Bob Phillips" <bob.NGs@xxxx.com>
wrote:

>They should store it in a directory, and then in Excel goto Tools>Addins,
>hit the browse button and find the addin file, and open it there. The addin
>will open with Excel each time from then on.

Yes, I know all that but how can they run it? The add-in is a simple
VBA-code to apply user-defined settings on a selected chart. They
select a chart and then....?

--
Fredrik E. Nilsen

Dave Peterson

12/17/2006 2:24:00 AM

0

You have to give them some interface to your subroutines.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips...

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlTool...
(from Debra Dalgleish's site)

"Fredrik E. Nilsen" wrote:
>
> I'm trying to create an add-in to distribute to several users. The
> add-in is used to apply user-defined chart-settings to excisting
> charts. I know how to create the code to apply the settings, to save
> it as an add-in and to load from tools -> add-ins...
>
> But: how can the user run the add-in?
>
> --
> Fredrik E. Nilsen

--

Dave Peterson

Gord Dibben

12/17/2006 2:28:00 AM

0

then..........they click on a button you have provided or a shortcut key combo.

They cannot run from Tools>Macro>Macros because they won't see any add-in
macros.


Gord Dibben MS Excel MVP

On Sun, 17 Dec 2006 03:16:43 +0100, Fredrik E. Nilsen
<fenilsen.nospam@chello.no> wrote:

>On Sun, 17 Dec 2006 02:04:10 -0000, "Bob Phillips" <bob.NGs@xxxx.com>
>wrote:
>
>>They should store it in a directory, and then in Excel goto Tools>Addins,
>>hit the browse button and find the addin file, and open it there. The addin
>>will open with Excel each time from then on.
>
>Yes, I know all that but how can they run it? The add-in is a simple
>VBA-code to apply user-defined settings on a selected chart. They
>select a chart and then....?

Fredrik E. Nilsen

12/17/2006 2:30:00 AM

0

On Sat, 16 Dec 2006 20:23:46 -0600, Dave Peterson
<petersod@verizonXSPAM.net> wrote:

>You have to give them some interface to your subroutines.
>
>For additions to the worksheet menu bar, I really like the way John Walkenbach
>does it in his menumaker workbook:
>http://j-walk.com/ss/excel/tips...
>
>Here's how I do it when I want a toolbar:
>http://www.contextures.com/xlTool...
>(from Debra Dalgleish's site)
>

Ah, fantastic! I have spendt hours trying to figure this out...

--
Fredrik E. Nilsen

Fredrik E. Nilsen

12/17/2006 2:33:00 AM

0

On Sat, 16 Dec 2006 18:27:49 -0800, Gord Dibben <gorddibbATshawDOTca>
wrote:

>then..........they click on a button you have provided or a shortcut key combo.
>
>They cannot run from Tools>Macro>Macros because they won't see any add-in
>macros.
>

Well, of course I have discovered that they can't run it from Tools ->
Macro. And you may have guessed that the question then is: How do I
provide a button to run it?

--
Fredrik E. Nilsen

ilia

12/17/2006 8:30:00 PM

0

ThisWorkbook.IsAddin = True