Thread: Create Add-in
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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....?