How to make an Add-in show under Run->Macro

[mliungman]

Hi!

I have two questions:

1. I just managed to create an Add-in on our server that shows up fine on my workstation. The macro is not available though. I can see it and run it in VBE, but it's not listed under Run --> Macro. How do I make it available?

2. Is it possible to have an Add-in loaded from the server? At the moment I have to copy the Add-in to my workstations. Each time a change is made in the server Add-in, I would have to reinstall the Add-in on all workstations. I would like to avoid that...

Martin

[Bob Phillips]

It doesn't show, but you can still run it by typing it in the textbox

myAddin.xla!MySub

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mliungman" <[email protected]> wrote
in message news:[email protected]...
>
> Hi!
>
> I just managed to create an Add-in on our server that shows up fine on
> my workstation. The macro is not available though. I can see it and run
> it in VBE, but it's not listed under Run --> Macro.
>
> Please advice!
>
> Martin
>
>
> --
> mliungman
> ------------------------------------------------------------------------
> mliungman's Profile:
http://www.excelforum.com/member.php...o&userid=30397
> View this thread: http://www.excelforum.com/showthread...hreadid=501594
>

[Bob Phillips]

BTW, functions will show in the function list.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mliungman" <[email protected]> wrote
in message news:[email protected]...
>
> Hi!
>
> I just managed to create an Add-in on our server that shows up fine on
> my workstation. The macro is not available though. I can see it and run
> it in VBE, but it's not listed under Run --> Macro.
>
> Please advice!
>
> Martin
>
>
> --
> mliungman
> ------------------------------------------------------------------------
> mliungman's Profile:
http://www.excelforum.com/member.php...o&userid=30397
> View this thread: http://www.excelforum.com/showthread...hreadid=501594
>

[Dave Peterson]

Give the user a way to run your macro.

If you want to add an option 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)



mliungman wrote:
>
> Hi!
>
> I just managed to create an Add-in on our server that shows up fine on
> my workstation. The macro is not available though. I can see it and run
> it in VBE, but it's not listed under Run --> Macro.
>
> Please advice!
>
> Martin
>
> --
> mliungman
> ------------------------------------------------------------------------
> mliungman's Profile: http://www.excelforum.com/member.php...o&userid=30397
> View this thread: http://www.excelforum.com/showthread...hreadid=501594

--

Dave Peterson

[mliungman]

Thanks guys!

You gave several answers to my first question, and the second solved itself. I was having computer problems, not VBA problems.

Martin