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....?
|