Create Add-in
 

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

Create Add-in
 

They should store it in a directory, and then in Excel goto ToolsAddins,
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" wrote in message
...
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

Create Add-in
 

On Sun, 17 Dec 2006 02:04:10 -0000, "Bob Phillips"
wrote:

They should store it in a directory, and then in Excel goto ToolsAddins,
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

Create Add-in
 

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

Create Add-in
 

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

They cannot run from ToolsMacroMacros 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
wrote:

On Sun, 17 Dec 2006 02:04:10 -0000, "Bob Phillips"
wrote:

They should store it in a directory, and then in Excel goto ToolsAddins,
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....?

Create Add-in
 

On Sat, 16 Dec 2006 20:23:46 -0600, Dave Peterson
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

Create Add-in
 

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 ToolsMacroMacros 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

Create Add-in
 

ThisWorkbook.IsAddin = True