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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

On Sun, 17 Dec 2006 02:04:10 -0000, "Bob Phillips" <(E-Mail Removed)>
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

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/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(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

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
<(E-Mail Removed)> wrote:

>On Sun, 17 Dec 2006 02:04:10 -0000, "Bob Phillips" <(E-Mail Removed)>
>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....?

On Sat, 16 Dec 2006 20:23:46 -0600, Dave Peterson
<(E-Mail Removed)> 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/tip53.htm
>
>Here's how I do it when I want a toolbar:
>http://www.contextures.com/xlToolbar02.html
>(from Debra Dalgleish's site)
>

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

--
Fredrik E. Nilsen

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

ThisWorkbook.IsAddin = True